Posible planner improvement? - Mailing list pgsql-performance

From Albert Cervera Areny
Subject Posible planner improvement?
Date
Msg-id 200805211228.48248.albert@sedifa.com
Whole thread Raw
Responses Re: Posible planner improvement?
Re: Posible planner improvement?
List 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 by date:

Previous
From: "J. Andrew Rogers"
Date:
Subject: Re: Varchar pkey instead of integer
Next
From: Frank Dekervel
Date:
Subject: Re: "append" takes a lot of time in a query