| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | "Woolcock, Sean" <Sean(dot)Woolcock(at)emc(dot)com> |
| Cc: | salah jubeh <s_jubeh(at)yahoo(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Request for help with slow query |
| Date: | 2012-10-29 19:32:43 |
| Message-ID: | 508ED9DB.2010301@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 10/29/2012 12:25 PM, Woolcock, Sean wrote:
>
> I thought that an index was implicitly created for foreign keys, but I see that that's not true. I've just created one now and re-ran the query but it did not change the query plan or run time.
1. Explain analyze, not explain please
Check to see if estimated rows differs wildly from actual.
2. Seriously... 8.1? That is not supported. Please upgrade to a
supported version of PostgreSQL.
http://www.postgresql.org/support/versioning/
3. Simple things:
A. Have you run analyze on the two tables?
B. What is your default_statistics_target?
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Thomas | 2012-10-29 19:36:21 | Re: Request for help with slow query |
| Previous Message | Woolcock, Sean | 2012-10-29 19:25:56 | Re: Request for help with slow query |