Re: 8.3.1 query plan

Tom Lane wrote:
> Steve Clark  writes:
> 
>>explain insert into myevents select * from t_unit_event_log a where exists
>>        (select b.event_log_no from myevents b
>>         where a.event_status = 1 and a.event_ref_log_no IS NOT NULL
>>                and a.event_ref_log_no = b.event_log_no and a.event_log_no not in
>>                        (select event_log_no from myevents)
>>        )
> 
> 
> Consider testing the conditions on A at the top level, instead of
> redundantly checking them inside the sub-query on B.  I'm not certain
> exactly how much that's hurting you (EXPLAIN ANALYZE output would've
> been more informative), but it can't be good.
> 
> 			regards, tom lane
> 
> 
Thanks for the response Tom, I am a SQL neophyte, so I'll try to rework the query. The explain analyze
runs forever, or longer than a day anyway.

Regards,
Steve