Postgres Pro
Downloads
Home   >   mailing lists

Select very slow... - Mailing list pgsql-sql

From Fernando Eduardo B. L. e Carvalho
Subject Select very slow...
Date
Msg-id 3AB47CBE.B3D44367@ig.com.br
Whole thread Raw
Responses Re: Select very slow...  (David Olbersen <dave@slickness.org>)
List pgsql-sql
Tree view 
   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?

pgsql-sql by date:

Previous
From: Richard Poole
Date:
Subject: Re: Oracle to PostgreSQL help: What is (+) in Oracle select?
Next
From: David Olbersen
Date:
Subject: Re: Select very slow...