Обсуждение: index find method?

Поиск
Список
Период
Сортировка

index find method?

От
"Jorge Medina"
Дата:
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.


Re: index find method?

От
"Rafael Domiciano"
Дата:
Hello,<br /><br />The Default method is btree, that is the commonly method used in the indexes.<br /><br />Rafael
Domiciano<br/>DBA Postgres<br />Senffnet<br /><br /><div class="gmail_quote">2008/6/18 Jorge Medina <<a
href="mailto:jorge@bsdchile.cl">jorge@bsdchile.cl</a>>:<br/><blockquote class="gmail_quote" style="border-left: 1px
solidrgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">hi list,<br /> when I do:<br /> CREATE INDEX
name_indexON some_table (some_col);<br /> what method(hash,btree,rtree,etc.) use by default?<br /><br /> --<br /> Jorge
AndrésMedina Oliva.<br /> Systems Manager and Developer.<br /> BSDCHiLE.<br /><font color="#888888"><br /> --<br />
Sentvia pgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br /> To make
changesto your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br />