Re: Out of memory error

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Clodoaldo Pinto <clodoaldo(dot)pinto(at)gmail(dot)com>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Out of memory error
Date: 2005-02-09 13:18:05
Message-ID: 1107955086.13633.79.camel@sabrina.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Mittwoch, den 09.02.2005, 10:39 -0200 schrieb Clodoaldo Pinto:
> On Wed, 09 Feb 2005 13:18:44 +0100, Tino Wildenhain <tino(at)wildenhain(dot)de> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-02-09 13:34:52 Re: Postgresql and Macintosh
Previous Message Clodoaldo Pinto 2005-02-09 12:39:00 Re: Out of memory error