Re: long wait times in ProcessCatchupEvent()

On 12/29/10 11:58 AM, Tom Lane wrote:
> 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 ...

My mistake - it was only 8.3.

Craig