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

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: José Soares <jose(at)sferacarta(dot)com>
Cc: hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows
Date: 1999-04-29 08:47:29
Message-ID: 37281CA1.8FC91744@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

José Soares wrote:
>
> $ time psql -f test.sql 2>/dev/null >/dev/null
> SELECT movimentazioni.azienda
> FROM movimentazioni,capi
> where ((capi.matricola = movimentazioni.matricola )
> and (capi.specie = movimentazioni.specie ) );
>
EXPLAIN ?

> $ time psql -f test.sql 2>/dev/null >/dev/null
> SELECT movimentazioni.azienda
> FROM movimentazioni,capi
> where (capi.specie = movimentazioni.specie )
> and ((capi.matricola = movimentazioni.matricola ))

EXPLAIN ?

Vadim

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas IZ5 1999-04-29 08:59:11 AW: [HACKERS] Pg takes at least 2 hours to retrieve 7650 rows
Previous Message José Soares 1999-04-29 08:30:46 Pg takes at least 2 hours to retrieve 7650 rows