Re: out of memory error

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:
>> a query on our production database give following errror:
>>
>> 2010-08-05 10:52:40 CEST [12106]: [278-1] ERROR:  out of memory
>> 2010-08-05 10:52:40 CEST [12106]: [279-1] DETAIL:  Failed on
>> request of size 48.

> What query?  On what OS?  Is this a 32-bit or 64-bit build of
> PostgreSQL?  How long does it run before failing.  What does memory
> usage look like before and during the run?

Also, out-of-memory should result in a memory usage map getting dumped
to the postmaster log.  That would be useful to see too.

            regards, tom lane