Re: [PERFORM] Help with nested loop left join performance

2006-02-22 Thread Tom Lane
Richard Huxton dev@archonet.com writes: George Woodring wrote: FROM settop_billing LEFT OUTER JOIN (dhct JOIN dhct_davic USING(mac)) USING (mac) WHERE region='GTown1E' AND node='1E012' With 7.4 I seem to remember that explicit

[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