Query execution plan from 8.3 -> 8.4
in [PgSql]
|
From: Stephen Frost on 12 May 2010 10:14 Brendan, * Brendan Hill (brendanh(a)jims.net) wrote: > Getting significantly lower performance on a specific query after upgrading > from 8.3 -> 8.4 (windows). I'm not expecting a quick fix from the mail > lists, but I would appreciate any indications as to where else I could look > or what tools I could employ to investigae further. Details below. For starters, this probably should go to -perform instead of -hackers, and it would be much more useful to have EXPLAIN ANALYZE results rather than just EXPLAIN. Thanks, Stephen
From: "Kevin Grittner" on 12 May 2010 10:29 "Brendan Hill" <brendanh(a)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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "Brendan Hill" on 12 May 2010 20:09 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(a)jims.net For emergencies: 1300 130 490 (intl +61 4 3456 5776) -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner(a)wicourts.gov] Sent: Thursday, 13 May 2010 12:29 AM To: Brendan Hill; pgsql-hackers(a)postgresql.org Subject: Re: [HACKERS] Query execution plan from 8.3 -> 8.4 "Brendan Hill" <brendanh(a)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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
|
Pages: 1 Prev: [HACKERS] Query execution plan from 8.3 -> 8.4 Next: [HACKERS] hot update doesn't work? |