2010/4/8 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
> 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.
postgresql 8.2: autovacuum enabled by default
postgresql 8.3: HOT (reduces update penalty -- zabbix does a lot of updates)
previous to 8.2, to get good performance on zabbix you need to
aggressively vacuum the heavily updated tables yourself.
merlin