On Wed, Mar 23, 2011 at 6:16 AM, Jesper Krogh <jesper@krogh.cc> wrote:
> On 2011-03-22 21:43, Robert Haas wrote:
>>
>> I took a crack at implementing the first approach described above,
>> which seems to be by far the simplest idea we've come up with to date.
>> Patch attached. It doesn't seem to be that complicated, which could
>> mean either that it's not that complicated or that I'm missing
>> something. Feel free to point and snicker in the latter case.
>
> Looks simple, but there is now benefit...
Your tests and discussion remind me that I haven't yet seen any tests
that show that index-only scans would be useful for performance.
Everyone just seems to be assuming that they make a huge difference,
and that the difference is practically realisable in a common
workload.
Perhaps that's already been done and I just didn't notice?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services