Re: Performance of count(*)

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: Performance of count(*)
Дата
Msg-id 200703221426.51948.mweilguni@sime.com
обсуждение исходный текст
Ответ на Re: Performance of count(*)  (ismo.tuononen@solenovo.fi)
Список pgsql-performance
Am Donnerstag, 22. März 2007 12:30 schrieb ismo.tuononen@solenovo.fi:
> approximated count?????
>
> why? who would need it? where you can use it?
>
> calculating costs and desiding how to execute query needs
> approximated count, but it's totally worthless information for any user
> IMO.

No, it is not useless. Try:
http://www.google.com/search?hl=de&q=test&btnG=Google-Suche&meta=

Do you really think google counted each of those individual 895 million
results? It doesn't. In fact, the estimate of google can be off by an order
of magnitude, and still nobody complains...


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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Potential memory usage issue
Следующее
От: Dimitri
Дата:
Сообщение: Parallel Vacuum