Re: Nested Loop "Killer" on 8.1

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Dave North <DNorth(at)signiant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Nested Loop "Killer" on 8.1
Date: 2009-06-25 20:16:42
Message-ID: 4A43DB2A.6@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dave,

> Is there further optimizations we can do to change the plan?
> Is this perhaps addressed in a later release?

Given the left joins, a later release might help; I know we did a lot to
improve left join plans in 8.3. It would be worth testing if you can
test an upgrade easily.

--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2009-06-25 20:36:43 Re: Nested Loop "Killer" on 8.1
Previous Message Mike Ivanov 2009-06-25 18:18:31 Re: Implications of having large number of users