Postgres Pro
Downloads
Home   >   mailing lists

Re: Killing dead index tuples before they get vacuumed - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Killing dead index tuples before they get vacuumed
Date
Msg-id 12360.1022088439@sss.pgh.pa.us
Whole thread Raw
In response to Re: Killing dead index tuples before they get vacuumed  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-hackers
Tree view 
Jan Wieck <janwieck@yahoo.com> writes:
> Tom Lane wrote:
>> Right, that's why I said that the limit would only go up to ~10K anyway;
>> btree won't take keys > 1/3 page.

>     What's the point then?

Well, btree's not the only index access method we have.  I'm not sure
whether gist or rtree allow larger tuples...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Killing dead index tuples before they get vacuumed
Next
From: Lamar Owen
Date:
Subject: Re: Redhat 7.3 time manipulation bug