Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?] - Mailing list pgsql-hackers

From Kris Kennaway
Subject Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]
Date
Msg-id 20070411020936.GA77953@xor.obsecurity.org
Whole thread Raw
In response to Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-hackers
On Wed, Apr 11, 2007 at 12:50:06PM +1200, Mark Kirkwood wrote:
> Tom Lane wrote:
>
> >
> >>I think the high number of setproctitle() calls are more problematic
> >>to us at the moment, Kris can comment on that.
> >
> >As of PG 8.2 it is possible to turn those off.  I don't think there's a
> >lot of enthusiasm for turning them off by default ... at least not yet.
> >But it might make sense to point out in the PG documentation that
> >update_process_title is particularly costly on platforms X, Y, and Z.
> >Do you know if this issue affects all the BSDen equally?
> >
>
>
> Might be good to turn off by default for the 8.2+ Postgresql versions in
> the FreeBSD ports tree (looks like postgresql.conf.sample is being
> patched anyway, so pretty easy to amend).

Yeah, we might end up doing this, but I consider it a workaround.

Kris

pgsql-hackers by date:

Previous
From: Kris Kennaway
Date:
Subject: Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]
Next
From: Kris Kennaway
Date:
Subject: Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]