Re: out of memory error

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <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:03:31
Message-ID: 4C5A7E630200002500034238@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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? (Sample of `vmstat 1` at
different points are good, if your OS supports that.)

> any suggestion ?

Read this page and post again with more detail:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Silvio Brandani 2010-08-05 14:10:12 Re: out of memory error
Previous Message Victor Hugo 2010-08-05 13:22:26 Re: out of memory error