Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 1D3B01337990 for ; Fri, 21 Jan 2011 16:19:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 49259-05 for ; Fri, 21 Jan 2011 20:19:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by mail.postgresql.org (Postfix) with ESMTP id 243DC1336FA7 for ; Fri, 21 Jan 2011 16:19:27 -0400 (AST) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis) id 0M944P-1PWAJr3wDt-00CRPL; Fri, 21 Jan 2011 21:19:23 +0100 Message-ID: <4D39EA49.5040809@2ndquadrant.com> Date: Fri, 21 Jan 2011 15:19:21 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: grant@amadensor.com CC: pgsql-performance@postgresql.org Subject: Re: Fun little performance IMPROVEMENT... References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:BBRSDmApJ6NmcRG8UhgZ/9R1AZB4jwYC1KY0lq2QkdO +oSsg7WGJXRoR+LlpgU4zjGwdllmZIODJLvuRnDM1kevyLflGX eW+RirPbwMHTDP64qFZNqU8EUfDscOXqzX+Rl09yDcgY64sBre lXlcnH0r7gRefasxgA4THF8neAaHhCJ8+5u3ZbA+ZXr8gwb2v4 iJunf1wfykvePYiVh+twgTmZrztcD4hZ2C81KulVo0= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201101/205 X-Sequence-Number: 41992 grant@amadensor.com wrote: > This was on a 4 CPU Xen virtual machine running > 8.1.22 on CENTOS. > You're not going to get anyone to spend a minute trying to figure what's happening on virtual hardware with an ancient version of PostgreSQL. If this was an actual full test case against PostgreSQL 8.4 or later on a physical machine, it might be possible to draw some conclusions about it that impact current PostgreSQL development. Note where 8.1 is on http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy for example. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books