On 4/6/22 3:28 PM, Chris Bisnett wrote:
On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
It can: https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS <https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS> Per-table value for vacuum_freeze_min_age parameter. > > - chris >-- Adrian Klaveradrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx> Oh I must have missed this. Is this missing from the documentation here (https://www.postgresql.org/docs/current/runtime-config-autovacuum.html <https://www.postgresql.org/docs/current/runtime-config-autovacuum.html>)?
That describes autovacuum in general. The per table options are attributes of a table.
I can try again, but I’m pretty sure this option was rejected when I attempted to set it via an alter table command.
What was the command you used? What was the error you got?
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
