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?
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
