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.
- [PERFORM] PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas
- Re: [PERFORM] PostgreSQL with Zabbix - problem o... Grzegorz Jaśkiewicz
- Re: [PERFORM] PostgreSQL with Zabbix - probl... Merlin Moncure
- Re: [PERFORM] PostgreSQL with Zabbix - p... Robert Haas
- Re: [PERFORM] PostgreSQL with Zabbix... Richard Yen
- Re: [PERFORM] PostgreSQL with Zabbix - p... Greg Smith
- Re: [PERFORM] PostgreSQL with Zabbix... Merlin Moncure
- Re: [PERFORM] PostgreSQL with Z... Scott Mead
- Re: [PERFORM] PostgreSQL with Zabbix - problem o... Greg Smith
- Re: [PERFORM] PostgreSQL with Zabbix - problem o... Greg Smith
- Re: [PERFORM] PostgreSQL with Zabbix - probl... Scott Marlowe
- Re: [PERFORM] PostgreSQL with Zabbix - probl... Merlin Moncure