Re: Killing dead index tuples before they get vacuumed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <janwieck(at)yahoo(dot)com>
Cc: Hannu Krosing <hannu(at)tm(dot)ee>, Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Killing dead index tuples before they get vacuumed
Date: 2002-05-22 17:27:19
Message-ID: 12360.1022088439@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jan Wieck <janwieck(at)yahoo(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bear Giles 2002-05-22 17:39:58 Security policy
Previous Message Jan Wieck 2002-05-22 17:14:17 Re: Killing dead index tuples before they get vacuumed