From: Dave Cramer <pg@fastcrypt.com>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: amrit angsusingh <amritspr@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Optimization postgresql 8.1.4 FC 6 X64 ?
Date: Sat, 24 Mar 2007 09:31:11 -0400
Message-ID: <4D8C02A8-88A4-4EFC-AA7F-0F0D688B505B@fastcrypt.com> (raw)
In-Reply-To: <4605011F.1040803@enterprisedb.com>
References: <3af7f950703232315g19e5d6d0o9ab54e489b8082c6@mail.gmail.com>
<4605011F.1040803@enterprisedb.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@fastcrypt.com, heikki@enterprisedb.com, amritspr@gmail.com
Subject: Re: Optimization postgresql 8.1.4 FC 6 X64 ?
In-Reply-To: <4D8C02A8-88A4-4EFC-AA7F-0F0D688B505B@fastcrypt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox