Re: [GENERAL] Evil Nested Loops

2009-06-03 Thread Scott Marlowe
On Wed, Jun 3, 2009 at 12:32 AM, Ow Mun Heng wrote: > What can I do about this plan? > > > > HashAggregate  (cost=8035443.21..8035445.17 rows=157 width=24) >  ->  Nested Loop  (cost=37680.95..7890528.72 rows=28982898 width=24) < > suspect >        Join Filter: ((a.test_run_start_date_time >=

Re: [GENERAL] Evil Nested Loops

2009-06-03 Thread Scott Marlowe
On Wed, Jun 3, 2009 at 2:18 AM, Ow Mun Heng wrote: > On Wed, 2009-06-03 at 01:28 -0600, Scott Marlowe wrote: >> On Wed, Jun 3, 2009 at 12:32 AM, Ow Mun Heng wrote: >> > HashAggregate  (cost=8035443.21..8035445.17 rows=157 width=24) >> >  ->  Nested Loop  (cost=37680.95..7890528.72 rows=28982898 w

Re: [GENERAL] Evil Nested Loops

2009-06-03 Thread Ow Mun Heng
On Wed, 2009-06-03 at 01:28 -0600, Scott Marlowe wrote: > On Wed, Jun 3, 2009 at 12:32 AM, Ow Mun Heng wrote: > > HashAggregate (cost=8035443.21..8035445.17 rows=157 width=24) > > -> Nested Loop (cost=37680.95..7890528.72 rows=28982898 width=24) < > > suspect > >Join Filter: ((a.t

[GENERAL] Evil Nested Loops

2009-06-02 Thread Ow Mun Heng
What can I do about this plan? HashAggregate (cost=8035443.21..8035445.17 rows=157 width=24) -> Nested Loop (cost=37680.95..7890528.72 rows=28982898 width=24) < suspect Join Filter: ((a.test_run_start_date_time >= date.start_time) AND (a.test_run_start_date_time <= date.end_ti