Postgres Pro
Downloads
Home   >   mailing lists

AW: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows - Mailing list pgsql-hackers

From Zeugswetter Andreas IZ5
Subject AW: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows
Date
Msg-id 219F68D65015D011A8E000006F8590C60267B354@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
Tree view 
> 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 capiwhat it could do if it was implemented is full index scan on
movimentazioni

pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows
Next
From: Atsushi Mano
Date:
Subject: ...