Message-ID: <4BBEAA10.6060808@2ndquadrant.com>
Date: Fri, 09 Apr 2010 00:16:16 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Merlin Moncure <mmoncure@gmail.com>
CC: =?UTF-8?B?R3J6ZWdvcnogSmHFm2tpZXdpY3o=?= <gryzman@gmail.com>,
	Krzysztof Kardas <krzychk2@gmail.com>, pgsql-performance@postgresql.org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
References: <v2w4ff8a7a31004080223mec26e053n69a2b80f24328f37@mail.gmail.com>	
	<n2s2f4958ff1004080231m2cc8602au9eaf7f6d0ecc8bd@mail.gmail.com>
	<p2ub42b73151004080616r994b020fp33350f9b982cf7b2@mail.gmail.com>
In-Reply-To: <p2ub42b73151004080616r994b020fp33350f9b982cf7b2@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Merlin Moncure wrote:
> postgresql 8.2: autovacuum enabled by default
> postgresql 8.3: HOT (reduces update penalty -- zabbix does a lot of updates)
>   

autovacuum wasn't enabled by default until 8.3.  It didn't really work 
all that well out of the box until the support for multiple workers was 
added in that version, along with some tweaking to its default 
parameters.  There's also a lot more logging information available, both 
the server logs and the statistics tables, to watch what it's doing that 
were added in 8.3.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us