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

From Grzegorz Jaśkiewicz
Subject Re: PostgreSQL with Zabbix - problem of newbe
Date
Msg-id n2s2f4958ff1004080231m2cc8602au9eaf7f6d0ecc8bd@mail.gmail.com
Whole thread Raw
In response to PostgreSQL with Zabbix - problem of newbe  (Krzysztof Kardas <krzychk2@gmail.com>)
Responses Re: PostgreSQL with Zabbix - problem of newbe  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
starting with 8.3, there's this new feature called HOT, which helps a lot when you do loads of updates.
Plus writer is much quicker (30-40% sometimes), and autovacuum behaves much nicer.
Bottom line, upgrade to 8.3, 8.1 had autovacuum disabled by default for a reason.

pgsql-performance by date:

Previous
From: Krzysztof Kardas
Date:
Subject: PostgreSQL with Zabbix - problem of newbe
Next
From: Merlin Moncure
Date:
Subject: Re: PostgreSQL with Zabbix - problem of newbe