I have asked him for the data and played with his queries, and obtained massive speedups with the following queries :
http://boutiquenumerique.com/pf/miroslav/query.sql http://boutiquenumerique.com/pf/miroslav/query2.sql http://boutiquenumerique.com/pf/miroslav/materialize.sql
Note that my optimized version of the Big Joins is not much faster that the materialized view without index (hash joins are damn fast in postgres) but of course using an index...
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
