Re: select count(*) performance

Поиск
Список
Период
Сортировка
От Detlef Rudolph
Тема Re: select count(*) performance
Дата
Msg-id 5i64cvF3mnmcsU1@mid.individual.net
обсуждение исходный текст
Ответ на select count(*) performance  (runic <runic@gmx.de>)
Ответы Re: select count(*) performance
Список pgsql-performance
Hello Group,

I've tried the VACUUM ANALYSE, that doesn't help
much, but VACUUM FULL improves Performance down
from about 40 secs to 8. I think in future I would
use the reltuples value from pg_class for the table.

Thanks a lot for your answers and a good Sunday,
Det

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