Postgres Pro
Downloads
Home   >   mailing lists

Re: how can I change a btree index into a hash index? - Mailing list pgsql-general

From Tom Lane
Subject Re: how can I change a btree index into a hash index?
Date
Msg-id 29397.1068678074@sss.pgh.pa.us
Whole thread Raw
In response to how can I change a btree index into a hash index?  (Mark Harrison <mh@pixar.com>)
Responses Re: how can I change a btree index into a hash index?  (Stephen Robert Norris <srn@commsecure.com.au>)
List pgsql-general
Tree view 
Mark Harrison <mh@pixar.com> writes:
> Since these are all unique things, and will only be tested for
> equality, I am guessing that making a hash index will be better
> than making a btree index.

You are mistaken.  If there were any real value in that, we'd offer
an easier way to do it.

            regards, tom lane

pgsql-general by date:

Previous
From: Alex
Date:
Subject: PL/PGSQL functions suddenly not working
Next
From: Christopher Murtagh
Date:
Subject: plpgsql return setof integer?