On Fri, Oct 26, 2007 at 01:10:42PM +0200, Reg Me Please wrote:
> prove=# explain analyze SELECT * from t_dati natural left join t_campi where
> tabe_id='CONTE';
> QUERY PLAN
>
------------------------------------------------------------------------------------------------------------------------------
> Hash Join (cost=3.95..382140.91 rows=274709 width=91) (actual
> time=1.929..57713.305 rows=92 loops=1)
> Hash Cond: (t_dati.camp_id = t_campi.camp_id)
Neither of the columns are indexed according to the schema you sent so
that's the problem. Or you broke something while "translating".
> (I translated the table and column names. The substance is the same.)
Try not translating, and we might get somewhere...
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.