Re: Setting a table to be ignored by autovacuum

Поиск
Список
Период
Сортировка
От Josh Kupershmidt
Тема Re: Setting a table to be ignored by autovacuum
Дата
Msg-id 4ec1cf761002180942y13e32418u5db6ed8565fc153d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting a table to be ignored by autovacuum  (Richard Huxton <dev@archonet.com>)
Ответы Re: Setting a table to be ignored by autovacuum
Список pgsql-general
Дерево обсуждения

On Thu, Feb 18, 2010 at 12:37 PM, Richard Huxton <dev@archonet.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

В списке pgsql-general по дате отправления: