On 12/29/10 11:58 AM, Tom Lane wrote:
Craig James<craig_james@xxxxxxxxxxxxxx> writes:
On 12/29/10 6:28 AM, Julian v. Bock wrote:
I have the problem that on our servers it happens regularly under a
certain workload (several times per minute) that all backend processes
get a SIGUSR1 and spend several seconds in ProcessCatchupEvent().
This sounds like the exact same problem I had on Postgres 8.3 and 8.4:
http://archives.postgresql.org/pgsql-performance/2010-04/msg00071.php
Updating to Postgres version 9 fixed it. Here is what appeared to be the best analysis of what was happening, but we never confirmed it.
http://archives.postgresql.org/pgsql-performance/2010-06/msg00464.php
It happened for you on 8.4 too? In that previous thread you were still
on 8.3. If you did see it on 8.4 then it wasn't sinval ...
My mistake - it was only 8.3.
Craig
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
