Re: Pre-allocated free space for row - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Pre-allocated free space for row
Date
Msg-id 8909.1125622296@sss.pgh.pa.us
Whole thread Raw
In response to Re: Pre-allocated free space for row  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I assume that for a vacuum that only hit pages indicated in the bitmap,
> it would still be necessary to do an index scan to remove the heap
> pointers in the index, right?

Given the current vacuum technology, yes.  However, bearing in mind that
indexes should generally be much smaller than their tables, cutting down
the table traversal is certainly the first-order problem.  (See also
discussion with Simon from today.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Pre-allocated free space for row
Next
From: Ricardo Humphreys
Date:
Subject: Avoid using swap in a cluster