Am Mittwoch, den 09.02.2005, 10:39 -0200 schrieb Clodoaldo Pinto: > On Wed, 09 Feb 2005 13:18:44 +0100, Tino Wildenhain <tino@xxxxxxxxxxxxx> wrote: > > > > Will this go into the same database? > > Yes, this *went* into the same database. > > > If so, you should probably use: > > > > CREATE TABLE targettable AS > > select data, > > usuario, > > sum(pontos) as sum_pontos, > > sum(wus) as sum_wus > > from usuarios > > group by data, usuario; > > > > Didn't try the create route. I have already performed the grouping. As > the table is big, each step takes very long and i don't have more time > to investigate further. Well the create table ... select is the most obvious for this kind of task. Maybe it helps next time. There are also some nice howtos on "kind of" materialized views - which looks like you want to do here. Regards Tino ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
