Re: PostgreSQL with Zabbix - problem of newbe

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, Krzysztof Kardas <krzychk2(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL with Zabbix - problem of newbe
Date: 2010-04-09 04:16:16
Message-ID: 4BBEAA10.6060808@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2010-04-09 06:32:38 Re: 3ware vs. MegaRAID
Previous Message Scott Carey 2010-04-09 03:28:27 Re: 3ware vs. MegaRAID