High Context-Switches on Linux 8.1.4 Server

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][

Responses

Browse pgsql-performance by date

  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