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 по дате отправления:

Предыдущее
От: "J. Andrew Rogers"
Дата:
Сообщение: Re: Varchar pkey instead of integer
Следующее
От: Frank Dekervel
Дата:
Сообщение: Re: "append" takes a lot of time in a query