postgres -> returns results in 2.8 seconds

What kind of plan does it do ? seq scan on the big tables and hash join on the small tables ?

mysql -> takes around 16 seconds !!!! (This is with myisam ... with innodb it takes 220 seconds)

        I'm not surprised at all.
Try the same Join query but with a indexed where + order by / limit on the big table and you should get even worse for MySQL. I found 3 tables in a join was the maximum the MySQL planner was able to cope with before blowing up just like you experienced.

I am all for postgres at this point, however just want to know why I am
getting opposite results !!! Both DBs are on the same machine

        Why do you say "opposite results" ?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to