Re: Setting a table to be ignored by autovacuum - Mailing list pgsql-general

On 18/02/10 17:20, Chris Barnes wrote:
>
> I'm trying to have this table ignored by the autovacuum process.
>
> It wasn't created with this in mind, hoping there is still a way?

> alter table schema.table SET (autovacuum_enabled = false);
>
> ERROR:  unrecognized parameter "autovacuum_enabled"

Close, but it's classed under storage parameters. You'll want to see the
SQL reference entry for "CREATE TABLE".

You might want to consider just turning the settings down rather than
off completely too.

--
   Richard Huxton
   Archonet Ltd