Re: INDEX and JOINs

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Reg Me Please <regmeplease(at)gmail(dot)com> writes:
>>> (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)

I think the reason it doesn't want to use an indexed join is the large
estimate of the number of join result rows.  You need to try to get that
number down to something nearer the reality.  Increasing the statistics
target for the larger table might help.

			regards, tom lane