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

From Mark Kirkwood
Subject Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]
Date
Msg-id 461C30BE.6050603@paradise.net.nz
Whole thread Raw
In response to Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]  (Kris Kennaway <kris@obsecurity.org>)
List pgsql-hackers
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).

Cheers

Mark



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]
Next
From: Koichi Suzuki
Date:
Subject: Re: [PATCHES] Full page writes improvement, code update