Re: [HACKERS] Slow count(*) again...

Поиск
Список
Период
Сортировка
От Conor Walsh
Тема Re: [HACKERS] Slow count(*) again...
Дата
Msg-id AANLkTi=XUprgXqV84iY1sukC_6Pos+DfVPFveaK1CSHf@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Slow count(*) again...  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] Slow count(*) again...
Список pgsql-performance
> I can't remember
> anyone ever complaining "ANALYZE took too long to run".  I only
> remember complaints of the form "I had to remember to manually run it
> and I wish it had just happened by itself".

Robert,

This sounds like an argument in favor of an implicit ANALYZE after all
COPY statements, and/or an implicit autoanalyze check after all
INSERT/UPDATE statements.

-Conor

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Slow count(*) again...
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [HACKERS] Slow count(*) again...