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?  (Simon Riggs <simon@2ndquadrant.com>)
Re: Why is indexonlyscan so darned slow?  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Why is indexonlyscan so darned slow?
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Bug in new buffering GiST build code