From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Setting a table to be ignored by autovacuum |
Date: | 2010-02-18 17:42:52 |
Message-ID: | 4ec1cf761002180942y13e32418u5db6ed8565fc153d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Barnes | 2010-02-18 17:47:44 | Re: Setting a table to be ignored by autovacuum |
Previous Message | Richard Huxton | 2010-02-18 17:37:23 | Re: Setting a table to be ignored by autovacuum |