2010/4/9 Greg Smith <greg@xxxxxxxxxxxxxxx>: > 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. you're right! iirc it was changed at the last minute... merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
