Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group