[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" wrote:
> AND Notes.Person_ID IN (SELECT
> ISNULL(Personnel.Person_ID, Busine
"Brendan Hill" 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 o
Brendan,
* Brendan Hill (brend...@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
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.
-Bren
