Re: INDEX and JOINs

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.