Re: Wierd context-switching issue on Xeon - Mailing list pgsql-performance

From pginfo
Subject Re: Wierd context-switching issue on Xeon
Date
Msg-id 40860509.C74D7457@t1.unisoftbg.com
Whole thread Raw
In response to Wierd context-switching issue on Xeon  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Hi,

Dual Xeon P4 2.8
linux RedHat AS 3
kernel 2.4.21-4-EL-smp
2 GB ram

I can see the same problem:

procs                      memory      swap          io
system         cpu
 r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy
id wa
1  0      0  96212  61056 1720240    0    0     0     0  101    11 25  0
75  0
 1  0      0  96212  61056 1720240    0    0     0     0  108   139 25
0 75  0
 1  0      0  96212  61056 1720240    0    0     0     0  104   173 25
0 75  0
 1  0      0  96212  61056 1720240    0    0     0     0  102    11 25
0 75  0
 1  0      0  96212  61056 1720240    0    0     0     0  101    11 25
0 75  0
 2  0      0  96204  61056 1720240    0    0     0     0  110 53866 31
4 65  0
 2  0      0  96204  61056 1720240    0    0     0     0  101 83176 41
5 54  0
 2  0      0  96204  61056 1720240    0    0     0     0  102 86050 39
6 55  0
 2  0      0  96204  61056 1720240    0    0     0    49  113 73642 41
5 54  0
 2  0      0  96204  61056 1720240    0    0     0     0  102 84211 40
5 55  0
 2  0      0  96204  61056 1720240    0    0     0     0  101 105165 39
7 54  0
 2  0      0  96204  61056 1720240    0    0     0     0  103 97754 38
6 56  0
 2  0      0  96204  61056 1720240    0    0     0     0  103 113668 36
7 57  0
 2  0      0  96204  61056 1720240    0    0     0     0  103 112003 37
7 56  0

regards,
ivan.


pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: Edoardo Ceccarelli
Date:
Subject: slow seqscan