Re: Performance of count(*)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Am Donnerstag, 22. März 2007 12:30 schrieb ismo.tuononen@xxxxxxxxxxx:
> 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...



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux