(Red Hat 3.4.6-9)
(1 row)
postgres=#
> Subject: Re: [GENERAL] Setting a table to be ignored by autovacuum
> From: dal...@solfertje.student.utwente.nl
> Date: Fri, 19 Feb 2010 12:24:24 +0100
> CC: schmi...@gmail.com; d...@archonet.com; pgsql-general@postgresql.org
> To: co
On 18 Feb 2010, at 18:47, Chris Barnes wrote:
> 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
>
>
> [postg...@pgprd01:~/pgcheck]$ psql
> Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
> Type: \copyright f
gmail.com; d...@archonet.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Setting a table to be ignored by autovacuum
>
> Chris Barnes escribió:
> >
> >
> >
> > Right you are, I'm due to upgrade end of month on this system.
> >
> > Her
Chris Barnes escribió:
>
>
>
> Right you are, I'm due to upgrade end of month on this system.
>
> Here I was thinking 8.4. Sorry for the spam.
You can "INSERT INTO pg_autovacuum VALUES ('schema.table'::regclass,
false, -1, -1, ...);" in previous versions.
--
Alvaro Herrera
h SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=#
From: schmi...@gmail.com
Date: Thu, 18 Feb 2010 12:42:52 -0500
Subject: Re: [GENERAL] Setting a table to be ignored by autovacuum
To: d...@archonet.c
On Thu, Feb 18, 2010 at 12:37 PM, Richard Huxton 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_enable
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, b
