On Mon, Jul 20, 2009 at 2:22 PM, Robert James<srobertjames@xxxxxxxxx> wrote: > BTW, this is interesting, because there are only about 5 or 6 rows max > returned from both queries - but I guess the planner expects more and hence > changes the plan to remove duplicates. If you sent the plans for the various attempts we might be able to explain what's going on. -- 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