On Mon, Jul 20, 2009 at 2:37 PM, Robert James<srobertjames@xxxxxxxxx> wrote: > I have two queries which should be equivalent. The Planner plans them > differently, although they are both about the same time. Can someone > explain why? Uhm, please post the two plans and the server version. I know you've posted them before but that was in another thread that I don't have handy. The short answer is that the server doesn't know that the subquery is definitely going to produce distinct results so it doesn't know the inner join won't produce duplicates. So it can't tell that these queries might be equivalent. -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
