2010/4/8 Grzegorz Jaśkiewicz <gryz...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
