Message-ID: <4BBE918C.7040105@2ndquadrant.com>
Date: Thu, 08 Apr 2010 22:31:40 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Krzysztof Kardas <krzychk2@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
In-Reply-To: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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