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@commandprompt.com
> To: compuguruchrisbarnes@hotmail.com
> CC: schmiddy@gmail.com; dev@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.
> >
> > 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

---

Windows® phone-your Windows stuff, on the go. See more.