Re: Why is indexonlyscan so darned slow?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Why is indexonlyscan so darned slow?
Дата
Msg-id 4FBAA8B2.7010601@agliodbs.com
обсуждение исходный текст
Ответ на Re: Why is indexonlyscan so darned slow?  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: Why is indexonlyscan so darned slow?
Re: Why is indexonlyscan so darned slow?
Список 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 по дате отправления: