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@2ndQuadrant.com www.2ndQuadrant.us