Re: Preventing index scans for non-recoverable index AMs

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Preventing index scans for non-recoverable index AMs
Date: 2008-12-17 23:12:52
Message-ID: 20081217231252.GA26318@it.is.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rice(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-12-17 23:14:31 Re: Preventing index scans for non-recoverable index AMs
Previous Message Kenneth Marshall 2008-12-17 23:10:40 Re: Preventing index scans for non-recoverable index AMs