X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 04FFC9FB22C for ; Fri, 28 Jul 2006 03:38:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11123-02 for ; Fri, 28 Jul 2006 03:38:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 785989FB223 for ; Fri, 28 Jul 2006 03:38:04 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so93430nfc for ; Thu, 27 Jul 2006 23:37:33 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=rCoFc2wQc0wFZA7afBSEwzJVYVSHWLSqr9sqjhaB7lftZ2XWkWRT4jxQ8yRZ1cTbxCSjUwVK9eCX6LHV5GudHX9r7hSwblJsySEVQ8xy7Mrkj1PXXwB9GsUU9toTxxZcs6sL94FKlXays8BKDhLK2ZCHLZS8p9ClK5W1PEC1Ajk= Received: by 10.49.55.13 with SMTP id h13mr328932nfk; Thu, 27 Jul 2006 23:37:33 -0700 (PDT) Received: by 10.49.64.6 with HTTP; Thu, 27 Jul 2006 23:37:33 -0700 (PDT) Message-ID: Date: Fri, 28 Jul 2006 08:37:33 +0200 From: "Kjell Tore Fossbakk" To: pgsql-performance@postgresql.org Subject: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_864_18983980.1154068653060" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.822 tagged_above=0 required=5 tests=AWL, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200607/257 X-Sequence-Number: 20117 ------=_Part_864_18983980.1154068653060 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline ---------- Forwarded message ---------- From: Kjell Tore Fossbakk Date: Jul 26, 2006 8:55 AM Subject: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 To: pgsql-performance-owner@postgresql.org Hello! I have upgraded my server to an HP Proliant DL585. It got two Processor motherboards, each holding an AMD/Opteron 2.6Ghz and 4GIG of memory. I got 4 150GIG SCSI disks in a Smart Array 5i 1+0 RAID. I'v been using Postgres for a few years, and the reason for this major hardware upgrade is to boost my performance. I have created a small web application that pulls huge amounts of data from my database. The database consists of basically one table, but it's big. It got 10 columns and a few indexes on the 3-4 most used fields (based on my queries of course). My queries use a few aggregated functions, such as sum and count, which makes the data moving process time-consuming. Now, on my older server (2gig memory and probabably some 2ghz cpu) my queries took quite a lot of time (30sec - several minutes). Now, with a much better hardware platform, I was hoping I could juice the process! As I have understood, there is alot of tuning using both postgres.conf and analyzing queries to make the values of postgres.conf fit my needs, system and hardware. This is where I need some help. I have looked into postgres.conf , and seen the tunings. But I'm still not sure what I should put into those variables (in postgres.conf) with my hardware. Any suggestions would be most appreciated! - Kjell Tore -- "Be nice to people on your way up because you meet them on your way down." -- "Be nice to people on your way up because you meet them on your way down." ------=_Part_864_18983980.1154068653060 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

---------- Forwarded message ----------
From: Kjell Tore Fossbakk <kjelltore@gmail.com>
Date: Jul 26, 2006 8:55 AM
Subject: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200
To: pgsql-performance-owner@postgresql.org

Hello!

I have upgraded my server to an HP Proliant DL585. It got two Processor motherboards, each holding an AMD/Opteron 2.6Ghz and 4GIG of memory.

I got 4 150GIG SCSI disks in a Smart Array 5i 1+0 RAID.

I'v been using Postgres for a few years, and the reason for this major hardware upgrade is to boost my performance. I have created a small web application that pulls huge amounts of data from my database.

The database consists of basically one table, but it's big. It got 10 columns and a few indexes on the 3-4 most used fields (based on my queries of course). My queries use a few aggregated functions, such as sum and count, which makes the data moving process time-consuming.

Now, on my older server (2gig memory and probabably some 2ghz cpu) my queries took quite a lot of time (30sec - several minutes). Now, with a much better hardware platform, I was hoping I could juice the process!

As I have understood, there is alot of tuning using both postgres.conf and analyzing queries to make the values of postgres.conf fit my needs, system and hardware. This is where I need some help. I have looked into postgres.conf , and seen the tunings. But I'm still not sure what I should put into those variables (in postgres.conf) with my hardware.

Any suggestions would be most appreciated!

- Kjell Tore

--
"Be nice to people on your way up because you meet them on your way down."


--
"Be nice to people on your way up because you meet them on your way down." ------=_Part_864_18983980.1154068653060--