| From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
|---|---|
| To: | postgres list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Slow response in select |
| Date: | 2010-09-21 12:25:55 |
| Message-ID: | 201009211325.55493.gary.stainburn@ringways.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi folks,I have a view that seems to be very slow compared to similar views on
the same server.
I've had a look at running explain but I don't really understand it.
I've posted the view and the output from explain at
http://www1.ringways.co.uk/explain.txt
This is an old view on a database that has been live for some time but I've
never managed to get to the bottom of why it's much slower than the other
views.
Gary
--
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 | Craig Ringer | 2010-09-21 14:11:09 | Re: Slow response in select |
| Previous Message | Adrian Johnson | 2010-09-21 11:57:59 | Help with queries. |