Re: Query Optimizer::7.3 to 7.4:: in() problems

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Rich Seiersen" <rich67dev(at)hotmail(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: Query Optimizer::7.3 to 7.4:: in() problems
Date: 2003-12-18 21:35:08
Message-ID: 200312181335.08421.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

Rich,

> We have noted a significant (seeming) slow down in the query optimizer from
> 7.3. to 7.4 as it relates to in() clauses. I reviewed some of Tom Lane's
> comments regarding the fact that it was actually optimized specifically - so
> our curiosity has been roused.

Hmmmm .... can we see the query plan in 7.3? The problem appears to be the
left join, not the IN() clause.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse sfpug by date

  From Date Subject
Next Message elein 2004-01-03 19:53:51 SFPUG meeting at Bucci's
Previous Message Stephan Szabo 2003-12-17 20:04:46 Re: Query Optimizer::7.3 to 7.4:: in() problems