From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: postgres list <pgsql-sql@postgresql.org>
Subject: Re: Slow response in select
Date: Tue, 21 Sep 2010 15:35:24 +0100
User-Agent: KMail/1.9.10
References: <201009211325.55493.gary.stainburn@ringways.co.uk>
	<4C98BCFD.10202@postnewspapers.com.au>
	<201009211520.15903.gary.stainburn@ringways.co.uk>
In-Reply-To: <201009211520.15903.gary.stainburn@ringways.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201009211535.24925.gary.stainburn@ringways.co.uk>

On Tuesday 21 September 2010 15:20:15 Gary Stainburn wrote:
>
> I've posted th explain analyze at
>
> http://www1.ringways.co.uk/explain_analyse.txt
>
> I've marked a line with a sort in that appears to be the bit that's taking
> the time.  Am I right?
>

I've had a look at this, and I can't even see why the sort is happeing. There 
are no order by clauses and only one group by clause in the sub-select. This 
group by only works on a very small dataset though.


-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000