Re: out of memory error - Mailing list pgsql-admin

From Tom Lane
Subject Re: out of memory error
Date
Msg-id 931.1281017723@sss.pgh.pa.us
Whole thread Raw
In response to Re: out of memory error  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: out of memory error
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: Silvio Brandani
Date:
Subject: Re: out of memory error
Next
From: Silvio Brandani
Date:
Subject: Re: out of memory error