Re: Query execution plan from 8.3 -> 8.4
От | Brendan Hill |
---|---|
Тема | Re: Query execution plan from 8.3 -> 8.4 |
Дата | |
Msg-id | 03f801caf230$8b0bf890$a123e9b0$@net обсуждение исходный текст |
Ответ на | Re: Query execution plan from 8.3 -> 8.4 ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
Список | 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@jims.net For emergencies: 1300 130 490 (intl +61 4 3456 5776) -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@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" <brendanh@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
В списке pgsql-hackers по дате отправления: