Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized table layout)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized table layout)
Дата
Msg-id 22013.1065302124@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] COUNT(*) again (was Re: Index/Function  (Hannu Krosing <hannu@tm.ee>)
Ответы Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized
Список pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> The point I was trying to make was that faster count(*)'s is just a side
> effect. If we could (conditionally) keep visibility info in indexes,

I think that's not happening, conditionally or otherwise.  The atomicity
problems alone are sufficient reason why not, even before you look at
the performance issues.

            regards, tom lane

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