Thread: index find method?
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.
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 />