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

From Gregory Stark
Subject Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]
Date
Msg-id 878xcz13tq.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: [mux@FreeBSD.org: Re: Anyone interested in improving postgresql scaling?]  (Kris Kennaway <kris@obsecurity.org>)
List pgsql-hackers
"Kris Kennaway" <kris@obsecurity.org> writes:

> If there really are users who find 10 proctitle updates/second an
> unacceptably low update rate, then tune for the default case and
> provide an option to allow them to override the rate limit to whatever
> update rate they find appropriate.

If you rate limit the naive way you would end up with info that's arbitrarily
old and out of date. To get something that's guaranteed not to be older than
some maximum age we would have to start with setting timers and setting the
proctitle in a signal handler which would be much more complex than what I
think you're imagining.


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Makefile patch to make gcov work on Postgres contrib modules
Next
From: Peter Eisentraut
Date:
Subject: Re: Makefile patch to make gcov work on Postgres contrib modules