From: | Chris Bisnett <cbisnett(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Per-Table vacuum_freeze_min_age |
Date: | 2022-04-06 22:45:28 |
Message-ID: | CADCOqPwCU_SWg4FqEwV7yWSpymFWZGfGa0E2tmr-bWuHGa7ZsQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 4/6/22 3:28 PM, Chris Bisnett wrote:
> > On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Lionel Bouton | 2022-04-06 23:05:32 | Re: What have I done!?!?!? :-) |
Previous Message | David G. Johnston | 2022-04-06 22:41:12 | Re: What have I done!?!?!? :-) |