Re: speeding up COUNT and DISTINCT queries

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: speeding up COUNT and DISTINCT queries
Дата
Msg-id 3E6FE59E.1050602@joeconway.com
обсуждение исходный текст
Ответ на Re: speeding up COUNT and DISTINCT queries  (Max Baker <max@warped.org>)
Ответы Re: speeding up COUNT and DISTINCT queries  (Max Baker <max@warped.org>)
Список pgsql-performance
Max Baker wrote:
> Thanks for the help.  I guess i'm not clear on why there is so much
> extra cruft.  Does postgres leave a little bit behind every time it does
> an update?  Because this table is updated constantly.
>

Yes. See:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/routine-vacuuming.html

Joe


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

Предыдущее
От: Max Baker
Дата:
Сообщение: Re: speeding up COUNT and DISTINCT queries
Следующее
От: Max Baker
Дата:
Сообщение: Re: speeding up COUNT and DISTINCT queries