Re: out of memory error

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