| From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
|---|---|
| To: | postgres list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Slow response in select |
| Date: | 2010-09-21 14:35:24 |
| Message-ID: | 201009211535.24925.gary.stainburn@ringways.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michele Petrazzo - Unipex | 2010-09-21 14:43:25 | Re: all the table values equal |
| Previous Message | Gary Stainburn | 2010-09-21 14:20:15 | Re: Slow response in select |