Re: index-only scans

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: index-only scans
Дата
Msg-id CA+TgmoZv_qoHZ4Fhmip429X_gfPuvBf0GC6xw=H1x3z+6DvNkg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: index-only scans  (Greg Smith <greg@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: index-only scans
Следующее
От: Tom Lane
Дата:
Сообщение: VACUUM FULL versus relcache init files