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

Reply via email to