Postgres 8.1.4
Slony 1.1.5
Linux manny 2.6.12-10-k7-smp #1 SMP Fri Apr 28 14:17:26 UTC 2006 i686
GNU/Linux
We're seeing an average of 30,000 context-switches a sec. This problem
was much worse w/8.0 and got bearable with 8.1 but slowly resurfaced.
Any ideas?
procs -----------memory---------- ---swap-- -----io---- --system--
----cpu----
r b swpd free buff cache si so bi bo in cs us sy
id wa
8 2 0 392184 40248 3040628 0 0 10012 2300 3371 43436 60
25 11 4
10 2 0 334772 40256 3043340 0 0 2672 1892 3252 10073 84
14 1 1
9 2 0 338492 40280 3051272 0 0 7960 1612 3548 22013 77
16 4 3
11 2 0 317040 40304 3064576 0 0 13172 1616 3870 42729 61
21 11 7
7 0 0 291496 40320 3078704 0 0 14192 504 3139 52200 58
24 12 7
The machine has 4 gigs of RAM, shared_buffers = 32768, max_connections =
400, and currently does around 300-500 queries a second. I can provide
more info if needed.
--
Sumbry][