Erik Rijkers wrote:
Hi Simon,
In another thread you mentioned you were lacking information from me:
On Tue, May 4, 2010 17:10, Simon Riggs wrote:
There is no evidence that Erik's strange performance has anything to do
with HS; it hasn't been seen elsewhere and he didn't respond to
questions about the test setup to provide background. The profile didn't
fit any software problem I can see.
I'm sorry if I missed requests for things that where not already mentioned.
Let me repeat:
OS: Centos 5.4
2 quadcores: Intel(R) Xeon(R) CPU X5482 @ 3.20GHz
Areca 1280ML
primary and standby db both on a 12 disk array (sata 7200rpm, Seagat
Barracuda ES.2)
It goes without saying (I hope) that apart from the pgbench tests
and a few ssh sessions (myself), the machine was idle.
It would be interesting if anyone repeated these simple tests and produced
evidence that these non-HS.
(Unfortunately, I have at the moment not much time for more testing)
FWIW - I'm seeing a behaviour here under pgbench -S workloads that looks
kinda related.
using -j 16 -c 16 -T 120 I get either 100000tps and around 660000
contextswitches per second or on some runs I end up with 150000tps and
around 1M contextswitches/s sustained. I mostly get the 100k result but
once in a while I get the 150k one. And one even can anticipate the
final transaction rate from watching "vmstat 1"...
I'm not sure yet on what is causing that behaviour but that is with
9.0B1 on a Dual Quadcore Nehalem box with 16 cpu threads (8+HT) on a
pure in-memory workload (scale = 20 with 48GB RAM).
Stefan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
