Re: Why is indexonlyscan so darned slow? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Why is indexonlyscan so darned slow?
Date
Msg-id 4FBAA8B2.7010601@agliodbs.com
Whole thread Raw
In response to Re: Why is indexonlyscan so darned slow?  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Why is indexonlyscan so darned slow?
Re: Why is indexonlyscan so darned slow?
List pgsql-hackers
> Earlier you said that this should be an ideal setup for IOS.  But it
> isn't really--the ideal set up is one in which the alternative to an
> IOS is a regular index scan which makes many uncached scattered reads
> into the heap.  I don't think that that situation can't really be
> engineered with a where-less query.

Can you give me some suggested comparisons which *would* be ideal, then?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Why is indexonlyscan so darned slow?
Next
From: Heikki Linnakangas
Date:
Subject: Re: Bug in new buffering GiST build code