Re: Setting a table to be ignored by autovacuum

Thanks Alvaro,

Hopefully it will stop my locking issue when I have high volume of changes on this table and vacuum starts.

Thx

Chris :)

> Date: Thu, 18 Feb 2010 16:55:24 -0300
> From: alvherre(at)commandprompt(dot)com
> To: compuguruchrisbarnes(at)hotmail(dot)com
> CC: schmiddy(at)gmail(dot)com; dev(at)archonet(dot)com; pgsql-general(at)postgresql(dot)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.
> >
> > 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 http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

_________________________________________________________________