Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

sfpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group