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
