Postgres Pro
Downloads
Home   >   mailing lists

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

From Matthew Wakeling
Subject Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Date
Msg-id alpine.DEB.2.00.1001251158130.6195@aragorn.flymine.org
Whole thread Raw
In response to Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL  (Richard Huxton <dev@archonet.com>)
Responses Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
List pgsql-performance
Tree view 
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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Next
From: Matthew Wakeling
Date:
Subject: Re: Sql result b where condition