Posible planner improvement?

Поиск
Список
Период
Сортировка
От Albert Cervera Areny
Тема Posible planner improvement?
Дата
Msg-id 200805211228.48248.albert@sedifa.com
обсуждение исходный текст
Ответы Re: Posible planner improvement?
Re: Posible planner improvement?
Список pgsql-performance
I've got a query similar to this:

select * from t1, t2 where t1.id > 158507 and t1.id = t2.id;

That took > 84 minutes (the query was a bit longer but this is the part that
made the difference) after a little change the query took ~1 second:

select * from t1, t2 where t1.id > 158507 and t2.id > 158507 and t1.id =
t2.id;

The change is pretty simple and it seems (note I don't have a clue on how the
planner works) it'd be possible for the planner to make this assumption
itself. Do you think it is really feasible/appropiate?



В списке pgsql-performance по дате отправления: