pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Donald C. Sumbry ][ <sumbry@revver.com>
To: pgsql-performance@postgresql.org
Subject: High Context-Switches on Linux 8.1.4 Server
Date: Mon, 07 Aug 2006 00:38:34 -0700
Message-ID: <44D6EDFA.4030802@revver.com> (raw)


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




view thread (5+ messages)  latest in thread

Message-ID: <44D6EDFA.4030802@revver.com>
Permalink:  ../44D6EDFA.4030802@revver.com/
Also on:    postgresql.org/message-id/44D6EDFA.4030802@revver.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sumbry@revver.com
  Subject: Re: High Context-Switches on Linux 8.1.4 Server
  In-Reply-To: <44D6EDFA.4030802@revver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox