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.
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
pgsql-performance by date
|Next:||From: Craig James||Date: 2010-12-29 19:28:25|
|Subject: Re: long wait times in ProcessCatchupEvent()|
|Previous:||From: Julian v. Bock||Date: 2010-12-29 14:28:34|
|Subject: long wait times in ProcessCatchupEvent()|