I also think there have been changes in pgbench itself.
Make sure you run the same pgbench on both servers.
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
>> 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
> TIP 7: You can help support the PostgreSQL project by donating at
In response to
pgsql-performance by date
|Next:||From: Bruce Momjian||Date: 2007-03-25 01:44:19|
|Subject: Re: Automatic adjustment of bgwriter_lru_maxpages|
|Previous:||From: Martijn van Oosterhout||Date: 2007-03-24 13:07:59|
|Subject: Re: EXISTS optimization|