On Tue, 20 Oct 2009, Bernd Helmle wrote:
--On 20. Oktober 2009 10:49:33 -0700 David Fetter <[email protected]> wrote:
track_activities (should be on)
track_counts (should be on)
update_process_title (should be on)
Removing all track* GUCs would only make sense if we are going to make
autovacuum mandatory, i think. And i thought update_process_title was
introduced due to performance complaints on some platforms which can't easily
be resolved?
Yes, update_process_title on FreeBSD defaults to 'off' as the overhead
based on how FreeBSD does the update was enough to make a noticeable
difference in performance ... suspect that is the same for all the *BSDs,
not sure about any other platform though ... maybe Windows?
----
Marc G. Fournier Hub.Org Hosting Solutions S.A.
[email protected] http://www.hub.org
Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:[email protected]
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers