Re: Per-Table vacuum_freeze_min_age - Mailing list pgsql-general

From Tom Lane
Subject Re: Per-Table vacuum_freeze_min_age
Date
Msg-id 3185187.1649283742@sss.pgh.pa.us
Whole thread Raw
In response to Per-Table vacuum_freeze_min_age  (Chris Bisnett <cbisnett@gmail.com>)
List pgsql-general
Chris Bisnett <cbisnett@gmail.com> writes:
> The only downside I’ve seen is that this is a global setting and my
> understanding is that this would cause decreased performance when used with
> tables with a lot of writes and deletes. Is there a technical reason this
> setting cannot be applied at the database or table context like other
> autovacuum settings?

There's an autovacuum_freeze_min_age reloption, isn't that
what you need?

            regards, tom lane



pgsql-general by date:

Previous
From: Chris Bisnett
Date:
Subject: Per-Table vacuum_freeze_min_age
Next
From: Adrian Klaver
Date:
Subject: Re: Per-Table vacuum_freeze_min_age