From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | David Olbersen <dave(at)slickness(dot)org> |
Cc: | "Fernando Eduardo B(dot) L(dot) e Carvalho" <feblec(at)ig(dot)com(dot)br>, Postgresql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Select very slow... |
Date: | 2001-03-19 23:54:06 |
Message-ID: | 3AB69C1E.2EE4841D@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2001-03-20 00:02:23 | Re: count() and multiple tables |
Previous Message | Josh Berkus | 2001-03-19 23:52:27 | Re: count() and multiple tables |