Skip site navigation (1) Skip section navigation (2)

Re: long wait times in ProcessCatchupEvent()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: long wait times in ProcessCatchupEvent()
Date: 2010-12-29 19:58:59
Message-ID: 304.1293652739@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Craig James <craig_james(at)emolecules(dot)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 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 ...

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2010-12-29 23:53:29
Subject: Re: long wait times in ProcessCatchupEvent()
Previous:From: Craig JamesDate: 2010-12-29 19:28:25
Subject: Re: long wait times in ProcessCatchupEvent()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group