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

From Francisco Reyes
Subject Re: pg_restore out of memory
Date
Msg-id cone.1182190258.198147.81364.5001@35st.simplicato.com
Whole thread Raw
In response to pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: pg_restore out of memory  (Vivek Khera <vivek@khera.org>)
Re: pg_restore out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_restore out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Vivek Khera writes:

> But that is a false assertion that the limit is 512Mb.  On a random
> system of mine running FreeBSD/i386 it shows the default data limit
> as 1Gb, and on a random FreeBSD/amd64 box I see it at about 32Gb.  I
> do no global tweaking of the size limits.

Understood.
I only showed "limit" because it was asked.
I already set /boot/loader.conf to 1600MB.
Also the error is about running out of memory when trying to allocate 84MB.
The default FreeBSD limit is 512MB so 84MB is well below that.

At this point this is basically stopping me from loading a table and so
far I have not been able to get any insight into how this could be fixed.

I wonder if there is any additional debuging I can turn on to help better
troubleshoot this.

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle
Next
From: "Matt Bartolome"
Date:
Subject: Re: pg_resetxlog command not found