| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Maxime Henrion <mux(at)freebsd(dot)org>, Kris Kennaway <kris(at)obsecurity(dot)org>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?] |
| Date: | 2007-04-11 00:50:06 |
| Message-ID: | 461C30BE.6050603@paradise.net.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Koichi Suzuki | 2007-04-11 01:09:43 | Re: [HACKERS] Full page writes improvement, code update |
| Previous Message | Kris Kennaway | 2007-04-11 00:40:27 | Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?] |