Re: PostgreSQL with Zabbix - problem of newbe

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