Re: Out of memory error - Mailing list pgsql-general

On Wed, 09 Feb 2005 13:18:44 +0100, Tino Wildenhain <tino@wildenhain.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.

Regards, Clodoaldo Pinto

>
> HTH
> Tino
>
>