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
pgpBiA1MKrVDJ.pgp
Description: PGP signature