On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 4/6/22 3:28 PM, Chris Bisnett wrote: > > On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver <adrian.kla...@aklaver.com > > <mailto:adrian.kla...@aklaver.com>> 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 Klaver > > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > > > 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.kla...@aklaver.com Either I was trying to use vacuum_freeze_min_age on the table or I forgot the parenthesis around the options in the alter table command. Either way, I just tried it and it worked. Thanks for the help! - chris
