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

From Kevin Grittner
Subject Re: out of memory error
Date
Msg-id 4C5A7E630200002500034238@gw.wicourts.gov
Whole thread Raw
In response to out of memory error  (Silvio Brandani <silvio.brandani@tech.sdb.it>)
Responses Re: out of memory error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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?  (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

pgsql-admin by date:

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