| From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
|---|---|
| To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
| Cc: | David Fetter <david(at)fetter(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Going, going, GUCs! |
| Date: | 2009-10-20 22:06:24 |
| Message-ID: | alpine.BSF.2.00.0910201905390.3709@hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 20 Oct 2009, Bernd Helmle wrote:
>
>
> --On 20. Oktober 2009 10:49:33 -0700 David Fetter <david(at)fetter(dot)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(at)hub(dot)org http://www.hub.org
Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy(at)hub(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-10-20 22:06:48 | Re: alpha2 release notes |
| Previous Message | Marc G. Fournier | 2009-10-20 22:05:25 | Re: Going, going, GUCs! |