Re: count(*) slow on large tables

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: count(*) slow on large tables
Дата
Msg-id 1065381109.23288.196.camel@jester
обсуждение исходный текст
Ответ на Re: count(*) slow on large tables  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
> And for those GUIs, wouldn't it be 97% as good to run an ANALYZE and give the
> approximate record counts for large tables?

Interfaces which run a COUNT(*) like that are broken by design. They
fail to consider the table may really be a view which of course could
not be cached with results like that and may take days to load a full
result set (we had some pretty large views in an old billing system).

Вложения

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: count(*) slow on large tables
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: reindex/vacuum locking/performance?