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: Tory M Blue <tmblue(at)gmail(dot)com>
Cc: Richard Huxton <dev(at)archonet(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-22 18:26:50
Message-ID: alpine.DEB.2.00.1001221825590.6195@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 22 Jan 2010, Tory M Blue wrote:
> But the same sql that returns maybe 500 rows is pretty fast, it's the return
> of 10K+ rows that seems to stall and is CPU Bound.

Okay, so you have two differing cases. Show us the EXPLAIN ANALYSE for
both of them, and we will see what the difference is.

Matthew

--
The third years are wandering about all worried at the moment because they
have to hand in their final projects. Please be sympathetic to them, say
things like "ha-ha-ha", but in a sympathetic tone of voice
-- Computer Science Lecturer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-01-22 18:38:21 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL
Previous Message Richard Huxton 2010-01-22 18:25:00 Re: Data Set Growth causing 26+hour runtime, on what we believe to be very simple SQL