Postgres Pro
Downloads
Home   >   mailing lists

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

From Chris Bisnett
Subject Re: Per-Table vacuum_freeze_min_age
Date
Msg-id CADCOqPwCU_SWg4FqEwV7yWSpymFWZGfGa0E2tmr-bWuHGa7ZsQ@mail.gmail.com
Whole thread Raw
In response to Re: Per-Table vacuum_freeze_min_age  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver <adrian.klaver@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.klaver@aklaver.com
> <mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@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.klaver@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 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: What have I done!?!?!? :-)
Next
From: Lionel Bouton
Date:
Subject: Re: What have I done!?!?!? :-)