Re: [HACKERS] Optimizer badness in 7.0 beta

This query can be rewritten as

SELECT creation_timestamp, etc. 
FROM game, game_developer
WHERE game.game_id = game_developer.game_id
  AND approved = 1 AND developer_id = 3
ORDER BY copyright_year desc, game_title

The way you're writing it you're almost asking it to be slow. :)

Of course that still doesn't explain why it's now 94sec versus formerly 1
but I'm sure Tom Lane will enlighten us all very soon. :)


Brian Hirt writes:

> select 
> 	creation_timestamp,
[snip]
> from 
> 	game 
> where 
> 	approved = 1 
> and 
> 	game_id in (
> 		select 
> 			distinct game_id
> 		from 
> 			game_developer
> 		where 
> 			developer_id = 3) 
> order by 
> 	copyright_year desc,
> 	game_title;


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden