> As for the counts on the tables: > table1 3,653,472 > table2 2,191,314 > table3 25,676,589 > > I think it's safe to assume right now that any resulting joins are not > one-to-one Hmmm? How is doing a subselect in the SELECT clause even working, then? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance