subject:"\[HACKERS\] Problem with the Planner"

Re: [HACKERS] Problem with the Planner

2006-01-15 Thread Gavin Sherry

On Mon, 16 Jan 2006, Anjan Kumar. A. wrote: > > > > Please observe the following queries. Why PostgreSQL is favouring MergeJoin > eventhough, it leading to higher execution times than NestedLoopJoin. Any > suggestions to fix this problem. > > > bench=# EXPLAIN ANALYZE SELECT * FROM tenk1 t1, ten

[HACKERS] Problem with the Planner

2006-01-15 Thread Anjan Kumar. A.

Please observe the following queries. Why PostgreSQL is favouring MergeJoin eventhough, it leading to higher execution times than NestedLoopJoin. Any suggestions to fix this problem. bench=# EXPLAIN ANALYZE SELECT * FROM tenk1 t1, tenk2 t2 WHERE t1.unique1 < 50 AND t1.unique2 = t2.unique2;