Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 562EDEC7B25 for ; Fri, 6 Jul 2012 00:08:35 -0300 (ADT) Received: from mail-gg0-f174.google.com ([209.85.161.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SmyuI-0000wI-FB for pgsql-performance@postgresql.org; Fri, 06 Jul 2012 03:08:34 +0000 Received: by gglu4 with SMTP id u4so8158663ggl.19 for ; Thu, 05 Jul 2012 20:08:22 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding :x-gm-message-state; bh=m+NU8Pb5OW6R1koBpsRBHUYBPU3oiMmx7zJOR0Ahy7w=; b=pT5BYkzqMLKOyuoFtBUGBr3VvmrVs5ZT42rQieZyl9FKx1hXYHdzP+LEiJfpo6R1jR o6NXtYo9m+SMS5aHqF+qsXflaGqR7GTqdRzYzctYtBYnF3s5XJUr/gO1dsJAem9CKHLa GqSeqd42igAhMQsMoFeW1r9i9orvkxnbdICFp3z6s1aGh5eEt0WeAPdtwdeE8mDxcRlc u2AlMyHMzRbs9rpJKlnjMhffoMXk7eYm4SsV7l7WATtYp407OUKe62P65PFfynlY3wmc zHxVAZ+rvzcO2Y7h3+/vIZ5GEF9sLnwMWHw7Z6tNG9Qc6TAjUv7SU1+rOMSb9zHosTOo RAsQ== Received: by 10.50.149.225 with SMTP id ud1mr1294852igb.74.1341544101521; Thu, 05 Jul 2012 20:08:21 -0700 (PDT) Received: from ayaki.localdomain (124-169-169-118.dyn.iinet.net.au. [124.169.169.118]) by mx.google.com with ESMTPS id nh1sm1508087igc.11.2012.07.05.20.08.19 (version=SSLv3 cipher=OTHER); Thu, 05 Jul 2012 20:08:20 -0700 (PDT) Message-ID: <4FF656A0.7040200@ringerc.id.au> Date: Fri, 06 Jul 2012 11:08:16 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120605 Thunderbird/13.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: The need for clustered indexes to boost TPC-V performance References: <66CE997FB523C04E9749452273184C6C137CB88A86@exch-mbx-113.vmware.com> <66CE997FB523C04E9749452273184C6C137CB88CF9@exch-mbx-113.vmware.com> <66CE997FB523C04E9749452273184C6C137CB88D2C@exch-mbx-113.vmware.com> <4FF63444.4030200@squeakycode.net> <66CE997FB523C04E9749452273184C6C137CC5C38D@exch-mbx-113.vmware.com> In-Reply-To: <66CE997FB523C04E9749452273184C6C137CC5C38D@exch-mbx-113.vmware.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQmYaw190LHLk6adziQ9RHuaN9vxUXF2mrhmNIjomv+h3CoDDNwnp1RCOAIG484Y5ZZNoxju X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/37 X-Sequence-Number: 47218 On 07/06/2012 09:00 AM, Reza Taheri wrote: > Well, I keep failing to send an email with an attachment. Do I need a moderator's approval? Probably. If so, it's really annoying that mailman isn't telling you this via a "held for moderation" auto-reply. It should be. > We stuck with PGSQL 8.4 since it is the stock version shipped with RHEL 6. I am building a new, larger testbed, and will switch to PGSQL 9 with that. Just so you know, as per PostgreSQL versioning policy major releases are x.y, eg "8.4", "9.0" and "9.1" are distinct major releases. http://www.postgresql.org/support/versioning/ I've always found that pretty odd and wish major releases would just increment the first version part, but the policy states how it's being done. It's important to realize this when you're talking about Pg releases, because 8.4, 9.0, 9.1 and 9.2 are distinct releases with different feature sets, so "postgresql 9" doesn't mean much. -- Craig Ringer