IBM has provided the PostgreSQL community with access to a couple of IBM POWER7 machines through OSUOSL. Simon has access to one, carved up into a couple of LPARs, for replication work, and there's a buildfarm animal on there as well, I think; I have access to the other, for performance testing. I imagine we can get access for a few other people as well, though at the moment the performance-testing machine is inaccessible and I'm not having very much luck getting help from the very busy OSUOSL folks. Anyway, before it bit the dust, I was able to do some basic pgbench tests at various scale factors and client counts. I used my usual settings:
shared_buffers = 8GB maintenance_work_mem = 1GB synchronous_commit = off checkpoint_segments = 300 checkpoint_timeout = 15min checkpoint_completion_target = 0.9 wal_writer_delay = 20ms I did three five-minute runs at each scale factors 100, 300, 1000, 3000, and 10000, with varying client counts: 1, 2, and all multiples of 4 up to 80. I stopped and restarted the database after each run (but did not flush the OS cache, so this is a warm-start test) and took the median of the three results for each run. Full results are attached herewith; pretty graphs are on my blog at http://rhaas.blogspot.com/2012/03/performance-and-scalability-on-ibm.html When I get the machine back, my plan is to next run some read-write pgbench tests. Those will need to be longer, though. Read performance doesn't seem to be very sensitive to the length of the tests, but write performance is, so I'll probably need at least 30-minute runs if not more to get an accurate sense of what the performance is like. After that I think maybe some testing of the remaining CommitFest patches might be in order (though personally I'd like to wrap this CommitFest up fairly soon) to see if any of those improve things. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
f.100
Description: Binary data
f.300
Description: Binary data
f.1000
Description: Binary data
f.3000
Description: Binary data
f.10000
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers