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 C81E89FB2C5 for ; Sun, 30 Jul 2006 16:18:43 -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 30169-02 for ; Sun, 30 Jul 2006 16:18:35 -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 06B2A9FB312 for ; Sun, 30 Jul 2006 16:18:04 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so292387nfc for ; Sun, 30 Jul 2006 12:18:03 -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=EgzPKlYWLcXtECq3CMTiNWxzXAU12Z3HJc97dWSqrS/UyUJOKzeB10IwxGrRRXMafoYnpVXOKEG43KSPV6L+RqIzEsJv04xdGleofOxY+JUwKX0xrvzf1rNKAgguD08RModq6Y2NiPeJtnGwTtSMVdnVVba6Sp/jD21WLcsDwbQ= Received: by 10.49.26.18 with SMTP id d18mr1404127nfj; Sun, 30 Jul 2006 12:18:03 -0700 (PDT) Received: by 10.49.64.6 with HTTP; Sun, 30 Jul 2006 12:18:03 -0700 (PDT) Message-ID: Date: Sun, 30 Jul 2006 21:18:03 +0200 From: "Kjell Tore Fossbakk" To: "Luke Lonergan" Subject: Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200 Cc: "Claus Guttesen" , pgsql-performance@postgresql.org In-Reply-To: <3E37B936B592014B978C4415F90D662D03EA1E86@MI8NYCMAIL06.Mi8.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23304_19133543.1154287083360" References: <3E37B936B592014B978C4415F90D662D03EA1E86@MI8NYCMAIL06.Mi8.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.089 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200607/290 X-Sequence-Number: 20150 ------=_Part_23304_19133543.1154287083360 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Okey! The thing is, im on vacation. So ill report in about 3 weeks time.. Sry guys.. :-) Kjell Tore On 7/30/06, Luke Lonergan wrote: > > Run bonnie++ version 1.03 and report results here. > > > - Luke > > Sent from my GoodLink synchronized handheld (www.good.com) > > > -----Original Message----- > From: Kjell Tore Fossbakk [mailto:kjelltore@gmail.com] > Sent: Sunday, July 30, 2006 03:03 PM Eastern Standard Time > To: Claus Guttesen > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and > 8gig DDR PC3200 > > 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." > > -- "Be nice to people on your way up because you meet them on your way down." ------=_Part_23304_19133543.1154287083360 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Okey!

The thing is, im on vacation. So ill report in about 3 weeks time.. Sry guys.. :-)

Kjell Tore

On 7/30/06, Luke Lonergan < LLonergan@greenplum.com> wrote:
Run bonnie++ version 1.03 and report results here.


- Luke

Sent from my GoodLink synchronized handheld (www.good.com)


-----Original Message-----
From:   Kjell Tore Fossbakk [mailto: kjelltore@gmail.com]
Sent:   Sunday, July 30, 2006 03:03 PM Eastern Standard Time
To:     Claus Guttesen
Cc:     pgsql-performance@postgresql.org
Subject:        Re: [PERFORM] Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200

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.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."




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