9.2 and index only scans

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема 9.2 and index only scans
Дата
Msg-id k1coqr$eeb$1@ger.gmane.org
обсуждение исходный текст
Ответы Re: 9.2 and index only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I'm playing around with 9.2 beta4 and was looking into the new Index Only Scan feature.

I was a bit surprised that a "count(*)" query does not use an index.
Not even a count(col) where col is the PK of the table.

Is that intended? If so, why is that the case?
I would have thought that this is an operation which is suitable to be served by an index only scan.

Regards
Thomas

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: postmaster.pid file auto-clean up?
Следующее
От: Matvey Teplov
Дата:
Сообщение: Question about granting permissions