Craig James <craig_james@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
