Re: select count(*) and limit

Hi,

Sean Davis schrieb:
> It should still work just fine, again with the caveat that it is an
> approximation and depends on the statistics available.  Try comparing the
> output a few times for your count(*) and using EXPLAIN.
>
sometimes the difference is to much to go this way. EXPLAIN extimates
71000 rows but there are 95000. 10% would have been accaptle. I did
these tests on a freshly vacuumed database.

regards,
Verena