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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
