Charavay, > --------------------------------------------------------------------------- >-------- Hash Join (cost=6793.29..1716853.80 rows=33743101 width=11) > Hash Cond: ("outer"."index" = "inner"."index") > -> Seq Scan on lnk (cost=0.00..535920.00 rows=33743100 width=15) > -> Hash (cost=4994.83..4994.83 rows=303783 width=4) > -> Seq Scan dic (cost=0.00..4994.83 rows=303783 width=4) > (5 rows)
According to the estimate, you are selecting all of the rows in the database. This is going to require a Seq Scan no matter what. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html