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
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
