Postgres Pro
Downloads
Home   >   mailing lists

Re: New strategies for freezing, advancing relfrozenxid early - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: New strategies for freezing, advancing relfrozenxid early
Date
Msg-id 78aecdaa345ea8cb1554ff2dbc08eb0e2262130a.camel@j-davis.com
Whole thread Raw
In response to Re: New strategies for freezing, advancing relfrozenxid early  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: New strategies for freezing, advancing relfrozenxid early  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view 
On Mon, 2022-10-03 at 22:45 -0700, Peter Geoghegan wrote:
> Once a table becomes larger than vacuum_freeze_strategy_threshold,
> VACUUM stops marking pages all-visible in the first place,
> consistently marking them all-frozen instead.

What are the trade-offs here? Why does it depend on table size?

Regards,
    Jeff Davis

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: problems with making relfilenodes 56-bits
Next
From: Nathan Bossart
Date:
Subject: Re: Suppressing useless wakeups in walreceiver