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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
