Re: Slow count(*) again...

Поиск
Список
Период
Сортировка
От Mladen Gogala
Тема Re: Slow count(*) again...
Дата
Msg-id 4CB37A7D.90502@vmsinfo.com
обсуждение исходный текст
Ответ на Re: Slow count(*) again...  (Neil Whelchel <neil.whelchel@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Neil Whelchel wrote:
>
>
> That is why I suggested an estimate(*) that works like (a faster) count(*)
> except that it may be off a bit. I think that is what he was talking about
> when he wrote this.
>
>
The main problem with "select count(*)" is that it gets seriously
mis-used.  Using "select count(*)" to establish existence is bad for
performance and for code readability.

--

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions

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

Предыдущее
От: Maciek Sakrejda
Дата:
Сообщение: Re: oracle to psql migration - slow query in postgres
Следующее
От: Damon Snyder
Дата:
Сообщение: Stored procedure declared as VOLATILE => no good optimization is done