| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | pgsql-admin(at)postgresql(dot)org, "Silvio Brandani" <silvio(dot)brandani(at)tech(dot)sdb(dot)it> |
| Subject: | Re: out of memory error |
| Date: | 2010-08-05 14:15:23 |
| Message-ID: | 931.1281017723@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Silvio Brandani | 2010-08-05 14:29:37 | Re: out of memory error |
| Previous Message | Silvio Brandani | 2010-08-05 14:10:12 | Re: out of memory error |