Postgres Pro
Downloads
Home   >   mailing lists

Re: "Out of memory" errors.. - Mailing list pgsql-general

From Tom Lane
Subject Re: "Out of memory" errors..
Date
Msg-id 4945.1187013106@sss.pgh.pa.us
Whole thread Raw
In response to "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
Responses Re: "Out of memory" errors..  ("Lim Berger" <straightfwd007@gmail.com>)
List pgsql-general
Tree view 
"Lim Berger" <straightfwd007@gmail.com> writes:
> ERROR:  out of memory
> DETAIL:  Failed on request of size 67108860.

Apparently, this number:

> maintenance_work_mem = 64MB

is more than your system can actually support.  Which is a bit odd for
any modern-day machine.  I suspect the postmaster is being started with
an unduly small ulimit.

            regards, tom lane

pgsql-general by date:

Previous
From: Alan J Batsford
Date:
Subject: Re: Problem Designing Index
Next
From: Tom Lane
Date:
Subject: Re: Unable to connect to PostgreSQL server via PHP