2009/10/30 Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>: > for explains, use http://explain.depesz.com/ > besides, why are you using left join ? > equivlent of IN () is just JOIN, not LEFT JOIN. > And please, format your query so it readable without twisting eyeballs > before sending. I prefer to have things posted to the list rather than some pastebin that may go away, but I agree that the email was unreadable as posted. Maybe an attachment? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
