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: infot...@jims.net For emergencies: 1300 130 490 (intl +61 4 3456 5776) -----Original Message----- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Thursday, 13 May 2010 12:29 AM To: Brendan Hill; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Query execution plan from 8.3 -> 8.4 "Brendan Hill" <brend...@jims.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
