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: bock(at)openit(dot)de (Julian v(dot) Bock)
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: long wait times in ProcessCatchupEvent()
Date: 2010-12-29 15:18:41
Message-ID: 10249.1293635921@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
bock(at)openit(dot)de (Julian v. Bock) writes:
> 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 is fixed in 8.4 and up.
http://archives.postgresql.org/pgsql-committers/2008-06/msg00227.php

If you aren't willing to move off 8.3 you might be able to ameliorate
the problem by reducing the volume of catalog changes, but that can be
pretty hard if you're dependent on temp tables.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2010-12-29 19:28:25
Subject: Re: long wait times in ProcessCatchupEvent()
Previous:From: Julian v. BockDate: 2010-12-29 14:28:34
Subject: long wait times in ProcessCatchupEvent()

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