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

Craig Ringer <ringerc@ringerc.id.au>

From: Craig Ringer <ringerc@ringerc.id.au>
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>
Date: 2012-07-06T01:04:20Z
Lists: pgsql-performance, pgsql-general
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

Commits

  1. Support index-only scans using the visibility map to avoid heap fetches.