Re: pg_restore out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Vivek Khera <vivek(at)khera(dot)org>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore out of memory
Date: 2007-06-18 20:21:30
Message-ID: 4476.1182198090@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Francisco Reyes <lists(at)stringsutils(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Staubo 2007-06-18 20:26:16 Re: unexpected shutdown
Previous Message Tom Lane 2007-06-18 20:19:18 Re: unexpected shutdown