Re: So, is COUNT(*) fast now?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: So, is COUNT(*) fast now?
Дата
Msg-id 6584.1319487807@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: So, is COUNT(*) fast now?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: So, is COUNT(*) fast now?
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Oct 24, 2011 at 3:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I wonder how trustworthy the measure of the visibilitymap_test call site
>> as a consumer of cycles really is.

> I'm not sure either.  I guess we could try short-circuiting
> visibilitymap_test and see what that does to performance (let's leave
> correct answers out of it).

That would conflate the cost of the call with the cost of the function.
Maybe you could try manually inlining the visibility test?
        regards, tom lane


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: So, is COUNT(*) fast now?
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Idea: Always consistent in-database cache using SSI mechanisms