Re: Indexscan API cleanup proposal

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Indexscan API cleanup proposal
Date: 2002-05-19 22:52:29
Message-ID: 11648.1021848749@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joe Conway <mail(at)joeconway(dot)com> writes:
> Tom Lane wrote:
>> where "kill the index entry" involves informing the index AM that it can
>> somehow mark the index entry uninteresting and not to be returned at all
>> during future indexscans.

> Is this a step toward being able to VACUUM indexes?

You mean collapse indexes? No, that's an entirely different issue.
This is about reducing scan overhead when an index contains lots of
pointers to dead-but-not-yet-vacuumed tuples.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dhruv Pilania 2002-05-19 23:24:28 getting oid of tuple in executePlan
Previous Message Joe Conway 2002-05-19 22:43:03 Re: Indexscan API cleanup proposal