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

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Tory M Blue <tmblue(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Date: 2010-01-25 11:59:41
Message-ID: alpine.DEB.2.00.1001251158130.6195@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!!

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2010-01-25 12:10:34 Re: Sql result b where condition
Previous Message Richard Huxton 2010-01-25 10:54:30 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL