I also think there have been changes in pgbench itself.
Make sure you run the same pgbench on both servers.
Dave
On 24-Mar-07, at 6:44 AM, Heikki Linnakangas wrote:
amrit angsusingh wrote:
I try to change my database server from the older one ie. 2Cpu
Xeon 2.4 32
bit 4Gb SDram Hdd SCSI RAID 5 and FC 3 ix86 with 7..4.7 PG to the
newer one
with 2CPU Xeon 3.0 64 Bit 4Gb DDRram SCSI Raid5 and FC6 X64 PG
8.14 and try
to use rather the same parameter from the previous
postgresql.conf :-
...
I use pgbench to test the speed of my older database server and
the result
is
bash-3.00$ pgbench test -t 20 -c 30 -s 50
...
-t 20 is not enough to give repeatable results. Try something like -
t 1000.
The speed of pgbench in that configuration (scaling factor 50,
fsync enabled) is limited by the speed you can fsync the WAL. There
isn't much you can do in postgresql.conf for that. If you get
similar results with higher -t setting, it may be because your new
RAID and drives have slightly higher latency.
You're better off testing with real queries with your real database.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of
broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
