Re: select count(*) and limit

Поиск
Список
Период
Сортировка
От Verena Ruff
Тема Re: select count(*) and limit
Дата
Msg-id 446CA0AF.1000001@triosolutions.at
обсуждение исходный текст
Ответ на Re: select count(*) and limit  (Sean Davis <sdavis2@mail.nih.gov>)
Ответы Re: select count(*) and limit  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-novice
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

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

Предыдущее
От: Verena Ruff
Дата:
Сообщение: Re: select count(*) and limit
Следующее
От: Sean Davis
Дата:
Сообщение: Re: select count(*) and limit