Re: Resurrecting per-page cleaner for btree

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org, teramoto(dot)junji(at)lab(dot)ntt(dot)co(dot)jp
Subject: Re: Resurrecting per-page cleaner for btree
Date: 2006-07-25 11:54:26
Message-ID: 8202.1153828466@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> I think the only serious objection to this would be that it'd mean that
>> tuples that should have an index entry might not have one.

> This can occurs when we do REINDEX after DELETE, because dead tuples are
> excluded on REINDEX.

Good point. So we already have that problem anyway ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-07-25 11:59:27 Re: pgsql: Remove hard-wired lists of timezone abbreviations in favor of
Previous Message Andrew Dunstan 2006-07-25 11:42:40 Re: root/administartor user check option.

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2006-07-25 12:07:50 Patch for units in postgresql.conf
Previous Message Sergey E. Koposov 2006-07-25 09:39:50 Re: patch implementing the multi-argument aggregates (SOC