On Mon, May 26, 2008 at 6:30 AM, ITAGAKI Takahiro
[EMAIL PROTECTED] wrote:
Albert Cervera Areny [EMAIL PROTECTED] wrote:
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
Moving to -hackers...
On May 21, 2008, at 9:09 AM, Richard Huxton wrote:
Luke Lonergan wrote:
The problem is that the implied join predicate is not being
propagated. This is definitely a planner deficiency.
IIRC only equality conditions are propagated and gt, lt, between
aren't. I seem
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
Albert Cervera Areny wrote:
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
A Dimecres 21 Maig 2008, Richard Huxton va escriure:
Albert Cervera Areny wrote:
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
A Dimecres 21 Maig 2008, Richard Huxton va escriure:
Albert Cervera Areny wrote:
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
A Dimecres 21 Maig 2008, Mark Mielke va escriure:
A Dimecres 21 Maig 2008, Richard Huxton va escriure:
Albert Cervera Areny wrote:
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
Subject: Re: [PERFORM] Posible planner improvement?
A Dimecres 21 Maig 2008, Albert Cervera Areny va escriure:
A Dimecres 21 Maig 2008, Mark Mielke va escriure:
A Dimecres 21 Maig 2008, Richard Huxton va escriure:
Albert Cervera Areny wrote:
I've got a query similar to this:
select
Luke Lonergan wrote:
The problem is that the implied join predicate is not being
propagated. This is definitely a planner deficiency.
IIRC only equality conditions are propagated and gt, lt, between aren't.
I seem to remember that the argument given was that the cost of
checking for the
On Wed, 21 May 2008 15:09:49 +0200, Richard Huxton [EMAIL PROTECTED]
wrote:
Luke Lonergan wrote:
The problem is that the implied join predicate is not being
propagated. This is definitely a planner deficiency.
IIRC only equality conditions are propagated and gt, lt, between aren't.
I
A Dimecres 21 Maig 2008, Richard Huxton va escriure:
Luke Lonergan wrote:
The problem is that the implied join predicate is not being
propagated. This is definitely a planner deficiency.
IIRC only equality conditions are propagated and gt, lt, between aren't.
I seem to remember that the
11 matches
Mail list logo