Re: [RFC] speed up count(*)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [RFC] speed up count(*)
Дата
Msg-id CA+TgmoY1V96j-BGJjxn7-DYA=iTTK46G02swqP7_NANMt4ig7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [RFC] speed up count(*)  (Joe Conway <mail@joeconway.com>)
Ответы Re: [RFC] speed up count(*)  (Joe Conway <mail@joeconway.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: parallelizing the archiver
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: parallelizing the archiver