X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A5E599FB29A for ; Thu, 3 Aug 2006 02:09:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 05788-09 for ; Thu, 3 Aug 2006 05:09:27 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 2140E9FB292 for ; Thu, 3 Aug 2006 02:09:26 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id z31so441782nzd for ; Wed, 02 Aug 2006 22:09:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=iTNybRbJFFyV/jNHk2xdTsW75Oz4qpLtca3zftpNEv08zquTl/vuSY6vbkQiQiR632cX2tWX3AyUNaF9M7NC9VzVVARXDejV1iluH5byqNWgWWT6ZPS+tRLSb1EnNkGN76RvlJOvaL+9MqeY2wb5DsemdJTPhETH9vMkmQGOeZs= Received: by 10.65.114.11 with SMTP id r11mr2555974qbm; Wed, 02 Aug 2006 22:09:22 -0700 (PDT) Received: by 10.64.179.18 with HTTP; Wed, 2 Aug 2006 22:08:52 -0700 (PDT) Message-ID: <5f820f750608022208ka5a2f81t4ac39d583685daf3@mail.gmail.com> Date: Thu, 3 Aug 2006 01:08:52 -0400 From: "Denis Lussier" To: "Florian Weimer" Subject: Re: Performances with new Intel Core* processors Cc: "Arjen van der Meijden" , "Merlin Moncure" , "Jonathan Ballet" , pgsql-performance@postgresql.org In-Reply-To: <8264hchq4a.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_67392_24977663.1154581732780" References: <44CDFD44.8080307@multani.info> <44CE3023.3020402@tweakers.net> <8264hchq4a.fsf@mid.bfk.de> X-Google-Sender-Auth: db3fbdea2492b8fe X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.191 tagged_above=0 required=5 tests=HTML_30_40, HTML_MESSAGE, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: **** X-Archive-Number: 200608/35 X-Sequence-Number: 20220 ------=_Part_67392_24977663.1154581732780 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline My theory, based entirely on what I have read in this thread, is that a low end server (really a small workstation) with an Intel Dual Core CPU is likely an excellent PG choice for the lowest end. I'll try to snag an Intel Dual Core workstation in the near future and report back DBT2 scores comparing it to a similarly equiped 1 socket AMD dual core workstation. I'll keep the data size small to fit entirely in RAM so the DBT2 isn't it's usual disk bound dog when you run it the "right" way (according to tpc-c guidelines). --Denis Dweeb from EnterpriseDB On 8/1/06, Florian Weimer wrote: > > * Arjen van der Meijden: > > > For a database system, however, processors hardly ever are the main > > bottleneck, are they? > > Not directly, but the choice of processor influences which > chipsets/mainboards are available, which in turn has some impact on > the number of RAM slots. (According to our hardware supplier, beyound > 8 GB, the price per GB goes up sharply.) Unfortunately, it seems that > the Core 2 Duo mainboards do not change that much in this area. > > -- > Florian Weimer > BFK edv-consulting GmbH http://www.bfk.de/ > Durlacher Allee 47 tel: +49-721-96201-1 > D-76131 Karlsruhe fax: +49-721-96201-99 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ------=_Part_67392_24977663.1154581732780 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline My theory, based entirely on what I have read in this thread, is that a low end server (really a small workstation) with an Intel Dual Core CPU is likely an excellent PG choice for the lowest end.

I'll try to snag an Intel Dual Core workstation in the near future and report back DBT2 scores comparing it to a similarly equiped 1 socket AMD dual core workstation.   I'll keep the data size small to fit entirely in RAM so the DBT2 isn't it's usual disk bound dog when you run it the "right" way (according to tpc-c guidelines).

--Denis
   Dweeb from EnterpriseDB

On 8/1/06, Florian Weimer <fweimer@bfk.de> wrote:
* Arjen van der Meijden:

> For a database system, however, processors hardly ever are the main
> bottleneck, are they?

Not directly, but the choice of processor influences which
chipsets/mainboards are available, which in turn has some impact on
the number of RAM slots.  (According to our hardware supplier, beyound
8 GB, the price per GB goes up sharply.)  Unfortunately, it seems that
the Core 2 Duo mainboards do not change that much in this area.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Durlacher Allee 47            tel: +49-721-96201-1
D-76131 Karlsruhe             fax: +49-721-96201-99

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

------=_Part_67392_24977663.1154581732780--