AW: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows

From: Zeugswetter Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: AW: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows
Date: 1999-04-29 08:59:11
Message-ID: 219F68D65015D011A8E000006F8590C60267B354@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Jewiss 1999-04-29 09:24:46 Re: [SQL] LIMIT
Previous Message Vadim Mikheev 1999-04-29 08:47:29 Re: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows