Re: Performance aggregates

If your query is not using the correct index files, you're query will run
slowly.  Please post the output from EXPLAIN.

-r

At 09:00 PM 5/15/01 +0200, snpe wrote:

>On Tuesday 15 May 2001 17:28, Stephan Szabo wrote:
> > On Tue, 15 May 2001, snpe wrote:
> > > Table e_kalkn have 4668 rows and e_kalkns 101170 rows.
> > >
> > > Query :
> > >
> > > select roba,sum(izn)
> > >  from e_kalkn k,e_kalkns ks
> > >  where k.id=ks.id
> > >  group by roba
> > >  order by roba
> > >
> > > is 2.5 times faster on one commercial database (there are tests on
> > > Internet that say 'Postgresql is faster than that database).
> > > I can't say which database it is.
> >
> > Have you run vacuum analyze (since loading the data) and what does explain
> > show for the query.  Also, what version are you using?
> >
>version postgresql 7.1.1
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01