Re: [PERFORM] Context switch storms

2008-12-05 Thread Kevin Grittner
>>> "Omar Kilani" <[EMAIL PROTECTED]> wrote: > During CS storm: > count(*) from pg_locks - 1000 - 1400 What do you have for max_connections? With the hardware and load you describe, I would guess you would limit context switching and see best performance with a connection pool that queues re

[PERFORM] Context switch storms

2008-12-02 Thread Omar Kilani
Hi there, We've recently started seeing some context switch storm issues on our primary Postgres database, and I was wondering if anyone had encountered similar issues or had any ideas as to what could be causing these issues. The machine configuration is: 8xIntel Xeon Harpertown 5430 (2.66GHz)