Request a Demo
Home   >   mailing lists

Re: index find method? - Mailing list pgsql-sql

From Rafael Domiciano
Subject Re: index find method?
Date
Msg-id 3a0028490806180903n7fe08849m26ba4a78ee5f6edf@mail.gmail.com
Whole thread Raw
In response to index find method?  ("Jorge Medina" <jorge@bsdchile.cl>)
List pgsql-sql
Tree view
Hello,

The Default method is btree, that is the commonly method used in the indexes.

Rafael Domiciano
DBA Postgres
Senffnet

2008/6/18 Jorge Medina <jorge@bsdchile.cl>:
hi list,
when I do:
CREATE INDEX name_index ON some_table (some_col);
what method(hash,btree,rtree,etc.) use by default?

--
Jorge Andrés Medina Oliva.
Systems Manager and Developer.
BSDCHiLE.

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: "Jorge Medina"
Date:
Subject: index find method?
Next
From: "Fernando Hevia"
Date:
Subject: Re: using calculated column in where-clause