On Wed, Dec 17, 2008 at 05:10:40PM -0600, Kenneth Marshall wrote: > On Wed, Dec 17, 2008 at 06:07:41PM -0500, Jaime Casanova wrote: > > On Wed, Dec 17, 2008 at 5:47 PM, Kenneth Marshall <k...@rice.edu> wrote: > > > Rebuilding a hash index for the case > > > for which it is preferred (large, large tables) would be excrutiating. > > > > > > > there's such a situation? > > > As of 8.4, yes. >
In addition, hash indexes can index items larger than the 1/3 page limit of btree indexes. Ken -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers