| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig James | 2010-12-29 23:53:29 | Re: long wait times in ProcessCatchupEvent() |
| Previous Message | Craig James | 2010-12-29 19:28:25 | Re: long wait times in ProcessCatchupEvent() |