Re: Going, going, GUCs!

On Tue, 20 Oct 2009, Bernd Helmle wrote:

>
>
> --On 20. Oktober 2009 10:49:33 -0700 David Fetter <david@fetter.org> 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.
scrappy@hub.org                                     http://www.hub.org

Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:scrappy@hub.org