Hi >>>>> "TL" == Tom Lane <tgl@xxxxxxxxxxxxx> writes: TL> bock@xxxxxxxxx (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(). TL> This is fixed in 8.4 and up. TL> http://archives.postgresql.org/pgsql-committers/2008-06/msg00227.php Thanks for the quick reply. TL> If you aren't willing to move off 8.3 you might be able to TL> ameliorate the problem by reducing the volume of catalog changes, TL> but that can be pretty hard if you're dependent on temp tables. Upgrading to 8.4 or 9.0 is not possible at the moment but if it is only catalog changes I can probably work around that. Regards, Julian v. Bock -- Julian v. Bock Projektleitung Software-Entwicklung OpenIT GmbH Tel +49 211 239 577-0 In der Steele 33a-41 Fax +49 211 239 577-10 D-40599 DÃsseldorf http://www.openit.de ________________________________________________________________ HRB 38815 Amtsgericht DÃsseldorf USt-Id DE 812951861 GeschÃftsfÃhrer: Oliver Haakert, Maurice Kemmann -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
