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 5191.1022082468@sss.pgh.pa.us
Whole thread Raw
In response to Re: Killing dead index tuples before they get vacuumed  (Jan Wieck <janwieck@yahoo.com>)
Responses Re: Killing dead index tuples before they get vacuumed  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-hackers
Jan Wieck <janwieck@yahoo.com> writes:
>     Also,  in  btree haven't we had some problems with index page
>     splits when using entries large enought so that not at  least
>     3 of them fit on a page?

Right, that's why I said that the limit would only go up to ~10K anyway;
btree won't take keys > 1/3 page.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Killing dead index tuples before they get vacuumed
Next
From: Tom Lane
Date:
Subject: Internal state in sequence.c is a bad idea