Re: pg_restore out of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore out of memory
Date
Msg-id 4476.1182198090@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Francisco Reyes <lists@stringsutils.com> writes:
> The issue I am trying to figure is which limit.. the OS limit is set to
> 1.6GB. I am now trying to increase my shared_buffers. So far have them at
> 450MB and it is still failing.

For this problem, increasing shared_buffers is either useless or
downright counterproductive.  It cannot increase the amount of temporary
workspace a particular backend can grab, and it might decrease it.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: unexpected shutdown
Next
From: "Alexander Staubo"
Date:
Subject: Re: unexpected shutdown