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 <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
