Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5F4369F9FE1 for ; Thu, 7 Dec 2006 06:29:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 74875-07 for ; Thu, 7 Dec 2006 06:29:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from olive.qinip.net (olive.qinip.net [62.100.30.40]) by postgresql.org (Postfix) with ESMTP id D38529F938C for ; Thu, 7 Dec 2006 06:29:44 -0400 (AST) Received: from [127.0.0.1] (h8441139206.dsl.speedlinq.nl [84.41.139.206]) by olive.qinip.net (Postfix) with ESMTP id 9375E1839C; Thu, 7 Dec 2006 11:29:40 +0100 (MET) Message-ID: <4577ED1C.1040600@tweakers.net> Date: Thu, 07 Dec 2006 11:29:48 +0100 From: Arjen van der Meijden User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Mindaugas CC: pgsql-performance@postgresql.org Subject: Re: Core 2 or Opteron References: <019401c719e9$07449d00$f20214ac@bite.lt> In-Reply-To: <019401c719e9$07449d00$f20214ac@bite.lt> Content-Type: text/plain; charset=windows-1257; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 0654-0, 06-12-2006), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/169 X-Sequence-Number: 22225 These benchmarks are all done using 64 bit linux: http://tweakers.net/reviews/646 Best regards, Arjen On 7-12-2006 11:18 Mindaugas wrote: > > Hello, > > We're planning new server or two for PostgreSQL and I'm wondering Intel > Core 2 (Woodcrest for servers?) or Opteron is faster for PostgreSQL now? > > When I look through hardware sites Core 2 wins. But I believe those tests > mostly are being done in 32 bits. Does the picture change in 64 bits? > > And I also remember that in PostgreSQL Opteron earlier had huge advantage > over older Xeons. But did Intel manage to change picture now? > > Thanks, > > Mindaugas > > > ---------------------------(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 >