Krzysztof Kardas wrote:
My current database variables:
That is way too much stuff to sort through. Try this instead, to only get the values you've set to something rather than every single one:
select name,unit,current_setting(name) from pg_settings where source='configuration file' ;
Also, a snapshot of output from "vmstat 1" during some period when the server is performing badly would be very helpful to narrow down what's going on.
The easy answer to your question is simply that autovacuum is terrible on PG 8.1. You can tweak it to do better, but that topic isn't covered very well in the sort of tuning guides you'll find floating around. This is because most of the people who care about this sort of issue have simply upgraded to a later version where autovacuum is much better.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
