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

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org, Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: Richard Huxton <dev(at)archonet(dot)com>
Subject: Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Date: 2010-01-25 22:17:14
Message-ID: 8a547c841001251417r7cbeb4fbo9e9734f09d56c159@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jan 25, 2010 at 3:59 AM, Matthew Wakeling <matthew(at)flymine(dot)org> wrote:
> 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

Thanks guys, ya this has dropped the time by half. The process is
manageable now. Thanks again. For some reason we thought this method
would make it take more time, vs less. So again appreciate the help :)

Tory

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message nair rajiv 2010-01-26 00:39:48 Re: splitting data into multiple tables
Previous Message Craig James 2010-01-25 19:31:38 Re: splitting data into multiple tables