Re: Preventing index scans for non-recoverable index AMs - Mailing list pgsql-hackers

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 <ktm@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