Re: PostgreSQL with Zabbix - problem of newbe - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: PostgreSQL with Zabbix - problem of newbe
Date
Msg-id l2lb42b73151004090806s84122169ibc27517b0816dd6f@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL with Zabbix - problem of newbe  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: PostgreSQL with Zabbix - problem of newbe
List pgsql-performance
2010/4/9 Greg Smith <greg@2ndquadrant.com>:
> 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.

you're right!  iirc it was changed at the last minute...

merlin

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: How check execution plan of a function
Next
From: Scott Mead
Date:
Subject: Re: PostgreSQL with Zabbix - problem of newbe