Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9156A9FB3BA for ; Sat, 24 Mar 2007 07:44:48 -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 26621-03 for ; Sat, 24 Mar 2007 07:44:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id F34BD9FB3B4 for ; Sat, 24 Mar 2007 07:44:44 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x4so2351205nfb for ; Sat, 24 Mar 2007 03:44:43 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=KXbCkDRWqFL+VpjIyAuMzfXQeFKGRyYLXmQUpaIl+sp6qQZ3GRB9V7RT4wGEh/9tXPfVAJlYNExKZhXHj2KegUf4RUumTWImgIORU9ygSYMBjF20po3vXcSo5Dp9AEOhMpoRxxV+57hz1xCxZsNOEWr0ijL3A4Y+Xq9LAeXXF44= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=mxyAkW8XmeHQnmPQJazoLTWHMFwdsC2iJNqUQV3OEARUXL0bzKc3Umv3yIwJQOVNjkV3oEkaKx4qkBHYpkQ+yTvK2mWNpc0jOTPBbukkK1uGuel1bPOJYTFV2T0gZ0Xx9lOlPXzpmRhKCODtKvGKzwOsPIkGsltDjqPAEw76RZo= Received: by 10.78.200.3 with SMTP id x3mr2017273huf.1174733083327; Sat, 24 Mar 2007 03:44:43 -0700 (PDT) Received: from ?192.168.1.34? ( [82.2.122.52]) by mx.google.com with ESMTP id c1sm14268276nfe.2007.03.24.03.44.37; Sat, 24 Mar 2007 03:44:38 -0700 (PDT) Message-ID: <4605011F.1040803@enterprisedb.com> Date: Sat, 24 Mar 2007 10:44:47 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: amrit angsusingh CC: pgsql-performance Subject: Re: Optimization postgresql 8.1.4 FC 6 X64 ? References: <3af7f950703232315g19e5d6d0o9ab54e489b8082c6@mail.gmail.com> In-Reply-To: <3af7f950703232315g19e5d6d0o9ab54e489b8082c6@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/388 X-Sequence-Number: 23793 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