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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden