Re: The need for clustered indexes to boost TPC-V performance - Mailing list pgsql-performance

From Craig Ringer
Subject Re: The need for clustered indexes to boost TPC-V performance
Date
Msg-id 4FF63994.8040009@ringerc.id.au
Whole thread Raw
In response to Re: The need for clustered indexes to boost TPC-V performance  (Andy Colson <andy@squeakycode.net>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Reza Taheri
Date:
Subject: Re: The need for clustered indexes to boost TPC-V performance
Next
From: Greg Smith
Date:
Subject: Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL