Message-ID: <4FF63994.8040009@ringerc.id.au>
Date: Fri, 06 Jul 2012 09:04:20 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: Andy Colson <andy@squeakycode.net>
CC: Samuel Gendler <sgendler@ideasculptor.com>,
	Reza Taheri <rtaheri@vmware.com>,
	Robert Klemme <shortcutter@googlemail.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: The need for clustered indexes to boost TPC-V performance
References: 
 <66CE997FB523C04E9749452273184C6C137CB88A86@exch-mbx-113.vmware.com>
	<CAM9pMnPxJ8i53aP=n7azT8sF5xiuWJzHPP-e-6qHdWozJCUbpw@mail.gmail.com>
	<66CE997FB523C04E9749452273184C6C137CB88CF9@exch-mbx-113.vmware.com>
	<CAEV0TzAFXapqsK4e98s4qxnNYFCm0ocYrrknb1h-Amta-OBh+w@mail.gmail.com>
	<66CE997FB523C04E9749452273184C6C137CB88D2C@exch-mbx-113.vmware.com>
	<CAEV0TzAZT0C62qdJO9wo=bKWVB6X2gTxVOVihRhgkX9B7kX6sw@mail.gmail.com>
	<4FF63444.4030200@squeakycode.net>
In-Reply-To: <4FF63444.4030200@squeakycode.net>
Content-Type: multipart/alternative;
	boundary="------------010902060809010606070207"

This is a multi-part message in MIME format.
--------------010902060809010606070207
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 07/06/2012 08:41 AM, Andy Colson wrote:

> You're running on windows then?  Server is 96Gig ram, 8 cores, (dell 
> poweredge T610).
> with two powervault MD1120 NAS's?

Thankfully they're running Pg on Linux (RHEL 6) . It seems that tests to 
date have been run against 8.4 which is pretty elderly, but hopefully 
it'll be brought up to 9.1 or 9.2beta soon.

While the original poster should've given a reasonable amount of 
information to start with when asking performance questions - as per the 
mailing list guidance and plain common sense - more info /was/ sent 
later on /but the lists.postgresql.org mailman ate it /- or held it for 
moderation, anyway. The OP can't be blamed when Pg's mailing list 
manager eats mesages with attachments! Also, remember that not everyone 
uses community mailing lists regularly; it takes a little learning to 
get used to keeping track of conversations, to inline reply style, etc.

--
Craig Ringer

--------------010902060809010606070207
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 07/06/2012 08:41 AM, Andy Colson
      wrote:<br>
      <br>
    </div>
    <blockquote cite="mid:4FF63444.4030200@squeakycode.net" type="cite">You're
      running on windows then?&nbsp; Server is 96Gig ram, 8 cores, (dell
      poweredge T610).
      <br>
      with two powervault MD1120 NAS's?
      <br>
    </blockquote>
    <br>
    Thankfully they're running Pg on Linux (RHEL 6) . It seems that
    tests to date have been run against 8.4 which is pretty elderly, but
    hopefully it'll be brought up to 9.1 or 9.2beta soon.<br>
    <br>
    While the original poster should've given a reasonable amount of
    information to start with when asking performance questions - as per
    the mailing list guidance and plain common sense - more info <i>was</i>
    sent later on <i>but the lists.postgresql.org mailman ate it </i>-
    or held it for moderation, anyway. The OP can't be blamed when Pg's
    mailing list manager eats mesages with attachments! Also, remember
    that not everyone uses community mailing lists regularly; it takes a
    little learning to get used to keeping track of conversations, to
    inline reply style, etc.<br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------010902060809010606070207--