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

Re: Optimization postgresql 8.1.4 FC 6 X64 ?

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: amrit angsusingh <amritspr(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Optimization postgresql 8.1.4 FC 6 X64 ?
Date: 2007-03-24 10:44:47
Message-ID: 4605011F.1040803@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Martijn van OosterhoutDate: 2007-03-24 13:07:59
Subject: Re: EXISTS optimization
Previous:From: amrit angsusinghDate: 2007-03-24 06:15:15
Subject: Optimization postgresql 8.1.4 FC 6 X64 ?

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