> > FWIW I suggest you provide the data in a form that's easier to use (like > a working SQL script). More people are likely to look and help than when > they have to extract stuff from an e-mail, fill in missing pieces etc. >
BTW if anyone wants to play with this, here are the SQL scripts I used to create the tables and the queries. There's no data, but it's enough to see how the plans change. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
query-complete.sql
Description: application/sql
query-smaller.sql
Description: application/sql
create-join.sql
Description: application/sql