From: | "Donald C(dot) Sumbry ][" <sumbry(at)revver(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | High Context-Switches on Linux 8.1.4 Server |
Date: | 2006-08-07 07:38:34 |
Message-ID: | 44D6EDFA.4030802@revver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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][
From | Date | Subject | |
---|---|---|---|
Next Message | Pit M. | 2006-08-07 09:48:50 | Re: Migrating data from DB2 to SQL Server |
Previous Message | Saranya Sivakumar | 2006-08-06 16:54:38 | 7.3.2 pg_restore very slow |