Re: [RFC] speed up count(*) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [RFC] speed up count(*)
Date
Msg-id CA+TgmoY1V96j-BGJjxn7-DYA=iTTK46G02swqP7_NANMt4ig7w@mail.gmail.com
Whole thread Raw
In response to Re: [RFC] speed up count(*)  (Joe Conway <mail@joeconway.com>)
Responses Re: [RFC] speed up count(*)
List pgsql-hackers
On Thu, Oct 21, 2021 at 4:19 PM Joe Conway <mail@joeconway.com> wrote:
> That is a grossly overstated position. When I have looked, it is often
> not that terribly far off. And for many use cases that I have heard of
> at least, quite adequate.

I don't think it's grossly overstated. If you need an approximation it
may be good enough, but I don't think it will often be exactly correct
- probably only if the table is small and rarely modified.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: parallelizing the archiver
Next
From: Stephen Frost
Date:
Subject: Re: parallelizing the archiver