[PERFORM] Help with nested loop left join performance

2006-02-21 Thread George Woodring
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] Query Performance and IOWait

2004-12-01 Thread George Woodring
Just as an update, We installed RHE Update4 beta kernel on a box and it seems to have solved our issues. Woody iGLASS Networks 211-A S. Salem St Apex NC 27502 (919) 387-3550 x813 www.iglass.net ---(end of broadcast)--

Re: [PERFORM] Help with query plan inconsistencies

2004-03-24 Thread George Woodring
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 2