Re: out of memory - Mailing list pgsql-performance

From Tom Lane
Subject Re: out of memory
Date
Msg-id 15115.1139931169@sss.pgh.pa.us
Whole thread Raw
In response to out of memory  (martial.bizel@free.fr)
Responses Re: out of memory  (martial.bizel@free.fr)
List pgsql-performance
martial.bizel@free.fr writes:
> I've error "out of memory" with these traces :

Doing what?

> AggContext: -1976573952 total in 287 blocks; 25024 free (414 chunks);
> -1976598976 used
> DynaHashTable: 503439384 total in 70 blocks; 6804760 free (257 chunks);
> 496634624 used

I'd guess that a HashAgg operation ran out of memory ...

            regards, tom lane

pgsql-performance by date:

Previous
From: martial.bizel@free.fr
Date:
Subject: out of memory
Next
From: "Jay Greenfield"
Date:
Subject: Postgres slower than MS ACCESS