Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Дата
Msg-id alpine.DEB.2.00.1001251158130.6195@aragorn.flymine.org
обсуждение исходный текст
Ответ на Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL  (Richard Huxton <dev@archonet.com>)
Ответы Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Список pgsql-performance
Дерево обсуждения 
On Mon, 25 Jan 2010, Richard Huxton wrote:
> OK - so the first query processes 19,799 rows in 31,219 ms (about 1.5ms per
> row)
>
> The second processes 2,606 rows in 3,813 ms (about 1.3ms per row).

Agreed. One query is faster than the other because it has to do an eighth
the amount of work.

Matthew

--
 I wouldn't be so paranoid if you weren't all out to get me!!

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: Sql result b where condition