Re: Setting a table to be ignored by autovacuum

Right you are, I'm due to upgrade end of month on this system.

Here I was thinking 8.4. Sorry for the spam.

Chris

[postgres(at)pgprd01:~/pgcheck]$ psql
Welcome to psql 8.3.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=#

From: schmiddy(at)gmail(dot)com
Date: Thu, 18 Feb 2010 12:42:52 -0500
Subject: Re: [GENERAL] Setting a table to be ignored by autovacuum
To: dev(at)archonet(dot)com
CC: compuguruchrisbarnes(at)hotmail(dot)com; pgsql-general(at)postgresql(dot)org

On Thu, Feb 18, 2010 at 12:37 PM, Richard Huxton <dev(at)archonet(dot)com> wrote:

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".

Hrmm.. I think the OP's syntax is correct, but he's probably using a version older than 8.4, when support for per-table autovacuum_enabled was added.

On HEAD:

test=# CREATE TABLE foo (a int);
CREATE TABLE
test=# alter table foo SET ( autovacuum_enabled=false) ;
ALTER TABLE
test=# \d+ foo
Table "public.foo"
Column | Type | Modifiers | Storage | Description
--------+---------+-----------+---------+-------------
a | integer | | plain |
Has OIDs: no
Options: autovacuum_enabled=false

Josh

_________________________________________________________________
Introducing Windows® phone.
http://go.microsoft.com/?linkid=9708122