"Stuart Bishop" <stuart@xxxxxxxxxxxxxxxx> writes: > For pgbench (PG 8.2 running Ubuntu), the Opteron is getting about 6x TPS > over the Xeon (3000+ TPS on Opteron vs ~500 on Xeon). Things get a little > better for Xeon with PG 8.3 (570-540 TPS). There was a problem in the past which affected Xeons. But I thought it had been mostly addressed. Xeons are (or were? these things are always changing) more sensitive to interprocess contention due to their memory architecture though. What are you actually doing in these transactions? Are they read-only? If not is fsync=off (which you don't want if you care about your data but you do if you're trying to benchmark the cpu). Are the crappy disks *identical* crappy disks? If they have different controllers or different drives (or different versions of the OS) then you might be being deceived by write caching on one set and not the other. If they're not read-only transactions and fsync=on then the TPS of 3000+ is not credible and this is likely. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
