Re: Query execution plan from 8.3 -> 8.4

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

In response to

Browse pgsql-hackers by date

  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