smiley2211 wrote: > > Hello all, > > I've made the changes to view to use UNION ALL and the where NOT IN > suggestions...the query now takes a little under 3 hours instead of 5 -- > here is the EXPLAIN ANALYZE:
It seems you have disabled nested loops --- why? Try turning them back on and let us see the EXPLAIN ANALYZE again. It would be extremely helpful if you saved it in a file and attached it separately so that the indentation and whitespace is not mangled by your email system. It would be a lot more readable that way. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
