Skip site navigation (1) Skip section navigation (2)

Re: Optimization postgresql 8.1.4 FC 6 X64 ?

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: amrit angsusingh <amritspr(at)gmail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Optimization postgresql 8.1.4 FC 6 X64 ?
Date: 2007-03-24 13:31:11
Message-ID: 4D8C02A8-88A4-4EFC-AA7F-0F0D688B505B@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-performance
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
>


In response to

pgsql-performance by date

Next:From: Bruce MomjianDate: 2007-03-25 01:44:19
Subject: Re: Automatic adjustment of bgwriter_lru_maxpages
Previous:From: Martijn van OosterhoutDate: 2007-03-24 13:07:59
Subject: Re: EXISTS optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group