| From: | "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com> |
|---|---|
| To: | "Jorge Medina" <jorge(at)bsdchile(dot)cl> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: index find method? |
| Date: | 2008-06-18 16:03:26 |
| Message-ID: | 3a0028490806180903n7fe08849m26ba4a78ee5f6edf@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)bsdchile(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando Hevia | 2008-06-18 19:35:48 | Re: using calculated column in where-clause |
| Previous Message | Jorge Medina | 2008-06-18 15:09:12 | index find method? |