Re: So, is COUNT(*) fast now? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: So, is COUNT(*) fast now?
Date
Msg-id 6584.1319487807@sss.pgh.pa.us
Whole thread Raw
In response to Re: So, is COUNT(*) fast now?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: So, is COUNT(*) fast now?
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: So, is COUNT(*) fast now?
Next
From: Alexander Korotkov
Date:
Subject: Idea: Always consistent in-database cache using SSI mechanisms