| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Brendan Hill" <brendanh(at)jims(dot)net>,<pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Query execution plan from 8.3 -> 8.4 |
| Date: | 2010-05-12 14:29:13 |
| Message-ID: | 4BEA74E9020000250003160A@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Brendan Hill" <brendanh(at)jims(dot)net> wrote:
> AND Notes.Person_ID IN (SELECT
> ISNULL(Personnel.Person_ID, Businesses.Main_Person_ID)
You might try switching this to an EXISTS test.
If you post on this topic again, really it should be on the -perform
list, as Stephen mentioned, and review this page for ideas on other
information (like hardware and the postgresql.conf file) which might
help people better understand the problem:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2010-05-12 14:40:19 | Re: max_standby_delay considered harmful |
| Previous Message | Stephen Frost | 2010-05-12 14:14:53 | Re: Query execution plan from 8.3 -> 8.4 |