Received: from smtp-2.ig.com.br (smtp-2.ig.com.br [200.225.157.61] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f2ICEsx19218 for ; Sun, 18 Mar 2001 07:14:54 -0500 (EST) (envelope-from feblec@ig.com.br) Received: (qmail 26793 invoked from network); 18 Mar 2001 12:14:48 -0000 Received: from unknown (HELO ig.com.br) (200.199.117.12) by smtp-2.ig.com.br with SMTP; 18 Mar 2001 12:14:48 -0000 Message-ID: <3AB47CBE.B3D44367@ig.com.br> Date: Sun, 18 Mar 2001 06:15:42 -0300 From: "Fernando Eduardo B. L. e Carvalho" X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.16-22 i686) X-Accept-Language: en MIME-Version: 1.0 To: Postgresql Subject: Select very slow... Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/341 X-Sequence-Number: 2005 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?