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

From: José Soares <jose(at)sferacarta(dot)com>
To: Vadim Mikheev <vadim(at)krs(dot)ru>
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 13:14:20
Message-ID: 37285B2C.47E5A353@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Vadim Mikheev ha scritto:

> 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 ?
>

explain SELECT movimentazioni.azienda
FROM movimentazioni,capi
where ((capi.matricola = movimentazioni.matricola )
and (capi.specie = movimentazioni.specie ) );
NOTICE: QUERY PLAN:

Hash Join (cost=1221.38 size=2 width=60)
-> Seq Scan on movimentazioni (cost=349.64 size=7565 width=36)
-> Hash (cost=0.00 size=0 width=0)
-> Seq Scan on capi (cost=335.55 size=7562 width=24)

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

explain SELECT movimentazioni.azienda
FROM movimentazioni,capi
where (capi.specie = movimentazioni.specie )
and ((capi.matricola = movimentazioni.matricola ));
NOTICE: QUERY PLAN:

Hash Join (cost=1221.38 size=2 width=60)
-> Seq Scan on movimentazioni (cost=349.64 size=7565 width=36)
-> Hash (cost=0.00 size=0 width=0)
-> Seq Scan on capi (cost=335.55 size=7562 width=24)

EXPLAIN

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message José Soares 1999-04-29 13:28:16 Re: [SQL] LIMIT
Previous Message Herouth Maoz 1999-04-29 11:42:18 Re: [HACKERS] Re: [GENERAL] unknown symbol 'lo_unlink'