Re: long wait times in ProcessCatchupEvent() - Mailing list pgsql-performance

From Tom Lane
Subject Re: long wait times in ProcessCatchupEvent()
Date
Msg-id 304.1293652739@sss.pgh.pa.us
Whole thread Raw
In response to Re: long wait times in ProcessCatchupEvent()  (Craig James <craig_james@emolecules.com>)
Responses Re: long wait times in ProcessCatchupEvent()
Re: long wait times in ProcessCatchupEvent()
List pgsql-performance
Craig James <craig_james@emolecules.com> 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
neverconfirmed 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 ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: long wait times in ProcessCatchupEvent()
Next
From: Craig James
Date:
Subject: Re: long wait times in ProcessCatchupEvent()