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 577819FB310 for ; Sun, 30 Jul 2006 16:02:12 -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 22441-09 for ; Sun, 30 Jul 2006 16:02:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id D67129FB2C5 for ; Sun, 30 Jul 2006 16:01:38 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so290076nfc for ; Sun, 30 Jul 2006 12:01:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=BuLyRU8qwzFS+y3efrURDcsGxCjwA35kQnZONA2uiNMuV4lc5lnPiQzL4l7PvSU++OUvvLMjsZD6y1I/t4kufO5GrMUxslTaIOlUnzNRrTj+dsjbvYZ9t0CWBBneYWhwk8SEI7E/CS6kmVqKme8iS8KHtTmTMzi7d7Af2JYAR4o= Received: by 10.48.48.18 with SMTP id v18mr1402111nfv; Sun, 30 Jul 2006 12:01:37 -0700 (PDT) Received: by 10.49.64.6 with HTTP; Sun, 30 Jul 2006 12:01:37 -0700 (PDT) Message-ID: Date: Sun, 30 Jul 2006 21:01:37 +0200 From: "Kjell Tore Fossbakk" To: "Claus Guttesen" Subject: Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23208_22229041.1154286097045" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.077 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200607/288 X-Sequence-Number: 20148 ------=_Part_23208_22229041.1154286097045 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello. OS: Gentoo 2006.0 with gentoo's hardened kernel Version: I haven't checked. Im guessing 8.0.8 (latest stable on all systems) or 8.1.4 which is the latest package. I'm still gonna try to run with smart array 5i. How can i find out that my performance with that is crappy? Without ripping down my systems, and using software raid? Kjell Tore On 7/28/06, Claus Guttesen wrote: > > > As I have understood, there is alot of tuning using both postgres.confand > > 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! > > What OS is it running and what version is postgresql? > > regards > Claus > -- "Be nice to people on your way up because you meet them on your way down." ------=_Part_23208_22229041.1154286097045 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello.

OS: Gentoo 2006.0 with gentoo's hardened kernel
Version: I haven't checked. Im guessing 8.0.8 (latest stable on all systems) or 8.1.4 which is the latest package.

I'm still gonna try to run with smart array 5i. How can i find out that my performance with that is crappy? Without ripping down my systems, and using software raid?

Kjell Tore

On 7/28/06, Claus Guttesen <kometen@gmail.com> wrote:
> 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!

What OS is it running and what version is postgresql?

regards
Claus



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