pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Joseph Shraibman <jks@selectacast.net>
To: David Olbersen <dave@slickness.org>
Cc: Fernando Eduardo B. L. e Carvalho <feblec@ig.com.br>
Cc: Postgresql <pgsql-sql@postgresql.org>
Subject: Re: Select very slow...
Date: Mon, 19 Mar 2001 18:54:06 -0500
Message-ID: <3AB69C1E.2EE4841D@selectacast.net> (raw)
References: <Pine.LNX.4.31.0103181038160.27741-100000@bubbles.electricutopia.net>

David Olbersen wrote:
> 
> On Sun, 18 Mar 2001, Fernando Eduardo B. L. e Carvalho wrote:
> 
> >   select  p.city,count(*) from sales s, person p where s.doc = p.doc
> > group by p.city;
> >
> >    Anyone help-me?
> 
> 1: VACUUM ANALYZE sales
>    VACUUM ANALYZE person;
> 
> 2: That 'count(*)' is going to be slow.
>    Try counting a column that's indexed (p.doc might work?)
> 
I don't think that is true.


--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com



view thread (19+ messages)  latest in thread

Message-ID: <3AB69C1E.2EE4841D@selectacast.net>
Permalink:  ../3AB69C1E.2EE4841D@selectacast.net/
Also on:    postgresql.org/message-id/3AB69C1E.2EE4841D@selectacast.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jks@selectacast.net, dave@slickness.org, feblec@ig.com.br
  Subject: Re: Select very slow...
  In-Reply-To: <3AB69C1E.2EE4841D@selectacast.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox