On 5/18/06 12:28 PM, "Verena Ruff" <lists(at)triosolutions(dot)at> wrote:
> 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.
You can change the statistics that are collected, if you like. Again, there
is stuff in the docs about doing that.
Sean