On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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 Klaver
> adrian.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
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
