Setting a table to be ignored by autovacuum

From: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Setting a table to be ignored by autovacuum
Date: 2010-02-18 17:20:56
Message-ID: BLU149-W65D825BFBA248A24FE5EA9D4470@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

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?

Thanks,

Chris

alter table schema.table SET (autovacuum_enabled = false);

ERROR: unrecognized parameter "autovacuum_enabled"


_________________________________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2010-02-18 17:37:23 Re: Setting a table to be ignored by autovacuum
Previous Message Carsten Kropf 2010-02-18 16:22:31 Re: Trying to add a type modifier to user created type