Re: [HACKERS] Optimizer badness in 7.0 beta
От | Peter Eisentraut |
---|---|
Тема | Re: [HACKERS] Optimizer badness in 7.0 beta |
Дата | |
Msg-id | Pine.LNX.4.21.0003051506410.347-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Optimizer badness in 7.0 beta (Brian Hirt <bhirt@mobygames.com>) |
Ответы |
Re: [HACKERS] Optimizer badness in 7.0 beta
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: