Re: index-only scans - Mailing list pgsql-hackers

From Robert Haas
Subject Re: index-only scans
Date
Msg-id CA+TgmoZv_qoHZ4Fhmip429X_gfPuvBf0GC6xw=H1x3z+6DvNkg@mail.gmail.com
Whole thread Raw
In response to Re: index-only scans  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-hackers
On Mon, Aug 15, 2011 at 7:37 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> That's 5.4X as fast; not too shabby!

Awesome!

> And with the large difference in response time, things appear to be working
> as hoped even in this situation.  If you try this on your laptop, where
> drive cache size and random I/O are likely to be even slower, you might see
> an ever larger difference.

Hah!  Just in case a 5.4X performance improvement isn't good enough?  :-)

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: index-only scans
Next
From: Tom Lane
Date:
Subject: VACUUM FULL versus relcache init files