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@xxxxxxxxxxxxxxxxx > To: compuguruchrisbarnes@xxxxxxxxxxx > CC: schmiddy@xxxxxxxxx; dev@xxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general Windows® phone-your Windows stuff, on the go. See more. |