Re: VACUUM (DISABLE_PAGE_SKIPPING on) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: VACUUM (DISABLE_PAGE_SKIPPING on)
Date
Msg-id 20201120160209.GA4994@alvherre.pgsql
Whole thread Raw
In response to Re: VACUUM (DISABLE_PAGE_SKIPPING on)  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: VACUUM (DISABLE_PAGE_SKIPPING on)  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2020-Nov-20, Robert Haas wrote:

> Yeah, I think dirtying the page fewer times is a big win. However, a
> page may have tuples that are not yet all-visible, and we can't freeze
> those just because we are freezing others.

Of course!  We should only freeze tuples that are freezable.  I thought
that was obvious :-)



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: xid wraparound danger due to INDEX_CLEANUP false
Next
From: Stephen Frost
Date:
Subject: Re: Disable WAL logging to speed up data loading