Select very slow...

From: "Fernando Eduardo B(dot) L(dot) e Carvalho" <feblec(at)ig(dot)com(dot)br>
To: Postgresql <pgsql-sql(at)postgresql(dot)org>
Subject: Select very slow...
Date: 2001-03-18 09:15:42
Message-ID: 3AB47CBE.B3D44367@ig.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Table 1

create table person (

doc text primary key,

etc ....

city text );

90000 rows

create table sales (

doc text,

etc .....

);

300000 rows

select p.city,count(*) from sales s, person p where s.doc = p.doc
group by p.city;

Anyone help-me?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Olbersen 2001-03-18 18:42:57 Re: Select very slow...
Previous Message jreniz 2001-03-17 05:22:44 Trigger problem