
> real    107m48.354s
> user    0m1.140s
> sys     0m0.040s
> 
Please give us output of:
	explain SELECT movimentazioni.azienda
> FROM movimentazioni,capi
> where ((capi.matricola = movimentazioni.matricola )
> and (capi.specie = movimentazioni.specie ) );
> 
	Andreas

	PS: what it should do is seq scan on movimentazioni and index path
on capi
	what it could do if it was implemented is full index scan on
movimentazioni

Thu, 29 Apr 1999 10:59:11 +0200
Zeugswetter Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
AW: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows