[PERFORM] Help with nested loop left join performance

I am running 7.4.8 and have a query that I have been running for a while that has recently have experienced a slowdown. The original query involves a UNION but I have narrowed it down to this half of the query as being my issue. (The other half take 4 seconds). The only issue that I have had is

Re: [PERFORM] Help with query plan inconsistencies

I currently have it set up to vacuum/analyze every 2 hours. However my QUERY PLAN #1 #2 in my example I ran my explain immediately after a vacuum/analyze. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joseph Shraibman Sent: Tuesday, March 23, 2004