X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 255DB528CE for ; Thu, 7 Jul 2005 10:03:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99310-04 for ; Thu, 7 Jul 2005 13:03:20 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 44F785288B for ; Thu, 7 Jul 2005 10:03:18 -0300 (ADT) Received: (qmail 9038 invoked from network); 7 Jul 2005 15:03:49 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 7 Jul 2005 15:03:49 +0200 Date: Thu, 07 Jul 2005 15:03:22 +0200 To: "Jean-Max Reymond" , pgsql-performance@postgresql.org Subject: Re: References: <4b09a0c0507070542fd0d197@mail.gmail.com> From: PFC Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-ID: In-Reply-To: <4b09a0c0507070542fd0d197@mail.gmail.com> User-Agent: Opera M2/8.0 (Linux, build 1095) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/66 X-Sequence-Number: 13307 > So, it seems that for my application (database in memory, 14 millions > of very small requests), Centrino (aka Pentium M) has a build-in > hardware to boost Postgres performance :-) > Any experience to confirm this fact ? On my Centrino, Python flies. This might be due to the very large processor cache. Probably it is the same for perl. With two megabytes of cache, sorting things that fit into the cache should be a lot faster too. Maybe this explains it. Check this out : http://www.anandtech.com/linux/showdoc.aspx?i=2308&p=5 http://www.anandtech.com/cpuchipsets/showdoc.aspx?i=2129&p=11 Bonus for Opteron lovers : "The Dual Opteron 252's lead by 19% over the Quad Xeon 3.6 GHz 667MHz FSB" http://www.anandtech.com/cpuchipsets/showdoc.aspx?i=2397&p=12