Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D74C29FB327 for ; Sat, 24 Mar 2007 10:31:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 50936-02 for ; Sat, 24 Mar 2007 10:30:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id 848B09FB317 for ; Sat, 24 Mar 2007 10:31:01 -0300 (ADT) Received: (qmail 28474 invoked from network); 24 Mar 2007 13:30:59 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.14?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 24 Mar 2007 13:30:59 -0000 In-Reply-To: <4605011F.1040803@enterprisedb.com> References: <3af7f950703232315g19e5d6d0o9ab54e489b8082c6@mail.gmail.com> <4605011F.1040803@enterprisedb.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <4D8C02A8-88A4-4EFC-AA7F-0F0D688B505B@fastcrypt.com> Cc: amrit angsusingh , pgsql-performance Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: Optimization postgresql 8.1.4 FC 6 X64 ? Date: Sat, 24 Mar 2007 09:31:11 -0400 To: Heikki Linnakangas X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/390 X-Sequence-Number: 23795 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 >