Re: long wait times in ProcessCatchupEvent()

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