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

On Thu, Jul 5, 2012 at 10:33 PM, Reza Taheri <rtaheri@vmware.com> wrote:
> Just to be clear, we have a number of people from different companies working on the kit. This is not a VMware
project,it is a TPC project. But I hear you regarding coming in from the cold and asking for a major db engine feature.
Iknow that I have caused a lot of rolling eyes. Believe me, I have had the same (no, worse!) reaction from every one of
thecommercial database companies in response to similar requests over the past 25 years. 

No rolling of eyes from me.  Clustered indexes work and if your table
access mainly hits the table through that index you'll see enormous
reductions in i/o.  Index only scans naturally are a related
optimization in the same vein.  Denying that is just silly.  BTW,
putting postgres through a standard non trivial benchmark suite over
reasonable hardware, reporting results, identifying bottlenecks, etc.
is incredibly useful.  Please keep it up, and don't be afraid to ask
for help here.  (one thing I'd love to see is side by side results
comparing 8.4 to 9.1 to 9.2).

merlin