From: | "Brendan Hill" <brendanh(at)jims(dot)net> |
---|---|
To: | "'Kevin Grittner'" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <pgsql-hackers(at)postgresql(dot)org>, "'Stephen Frost'" <sfrost(at)snowman(dot)net> |
Subject: | Re: Query execution plan from 8.3 -> 8.4 |
Date: | 2010-05-13 00:09:03 |
Message-ID: | 03f801caf230$8b0bf890$a123e9b0$@net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thanks for the advice, will do.
Regards,
Brendan Hill
Chief Information Officer
Jims Group Pty Ltd
48 Edinburgh Rd
Mooroolbark VIC 3138
www.jims.net
For all Jims IT enquiries: infotech(at)jims(dot)net
For emergencies: 1300 130 490 (intl +61 4 3456 5776)
-----Original Message-----
From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
Sent: Thursday, 13 May 2010 12:29 AM
To: Brendan Hill; pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Query execution plan from 8.3 -> 8.4
"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 | Tatsuo Ishii | 2010-05-13 00:24:52 | How to know killed by pg_terminate_backend |
Previous Message | Marc G. Fournier | 2010-05-13 00:04:42 | Re: List traffic |