On Tue, Jan 6, 2009 at 2:07 PM, Dan Armbrust <daniel.armbrust.list@xxxxxxxxx> wrote: > > Actually, the customer reported problem is that when they enable > autovacuum, the performance basically tanks because vacuum runs so > slow they can't bear to have it run frequently. Actually this is kinda backwards. What's happening is that the vacuum uses up so much IO that nothing else can get through. The answer is to make it run slower, by use of autovacuum_vacuum_cost_delay, and setting it to 10 or 20 and seeing if they can then run autovacuum during the day without these issues. Note that vacuum was improved a fair bit from 8.1 to 8.2 and even moreso from 8.2 to 8.3. > Though, perhaps they had bloated indexes before they started > autovacuum, and it never fixed them. Perhaps it will behave properly > if we do a reindex, and then enable autovacuum. Definitely look at the cost_delay setting. Makes a huge difference. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
