Re: Automatic free space map filling - Mailing list pgsql-hackers

From Zeugswetter Andreas DCP SD
Subject Re: Automatic free space map filling
Date
Msg-id E1539E0ED7043848906A8FF995BDA579D98D6E@m0143.s-mxs.net
Whole thread Raw
In response to Automatic free space map filling  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Automatic free space map filling  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> > But you could do the indexes first and remember how far you
> can vacuum
> > the heap later.
>
> But the indexes _can't_ be done first; you _first_ need to
> know which tuples are dead, which requires looking at the
> table itself.

If we already had the "all tuples visible" bitmap I think we could
first scan the bitmap and decide whether we can afford to look
at the visibility info for each entry in the index.

We only collect the ctids before so we don't have the inefficient
lookups,
but if we can avoid the lookup in most cases it would again be
attractive.

Andreas


pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: [PATCHES] LDAP auth
Next
From: Q Beukes
Date:
Subject: Real Life Data