From: sathiya psql <sathiya.psql@gmail.com>
To: Franck Routier <franck.routier@axege.com>
To: pgsql-performance@postgresql.org
Subject: Re: pg_restore : out of memory
Date: Fri, 19 Dec 2008 13:30:36 +0530
Message-ID: <f966c2ee0812190000y698ddb74i7d886b492a01ca7@mail.gmail.com> (raw)
In-Reply-To: <1228399715.16894.22.camel@franck-laptop>
References: <1228399715.16894.22.camel@franck-laptop>
On Thu, Dec 4, 2008 at 7:38 PM, Franck Routier <franck.routier@axege.com>wrote:
> Hi,
>
> I am trying to restore a table out of a dump, and I get an 'out of
> memory' error.
>
> The table I want to restore is 5GB big.
>
> Here is the exact message :
>
> admaxg@goules:/home/backup-sas$ pg_restore -F c -a -d axabas -t cabmnt
> axabas.dmp
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 5492; 0 43701 TABLE
> DATA cabmnt axabas
> pg_restore: [archiver (db)] COPY failed: ERROR: out of memory
> DETAIL: Failed on request of size 40.
> CONTEXT: COPY cabmnt, line 9038995: "FHSJ CPTGEN RE
> 200806_004 6.842725E7 6.842725E7 \N 7321100 1101
> \N
> 00016 \N \N \N \N \N \N -1278.620..."
> WARNING: errors ignored on restore: 1
>
> Looking at the os level, the process is effectively eating all memory
> (incl. swap), that is around 24 GB...
>
how are you ensuring that it eats up all memory..
post those outputs ?
>
> So, here is my question : is pg_restore supposed to eat all memory ? and
> is there something I can do to prevent that ?
>
> Thanks,
>
> Franck
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sathiya.psql@gmail.com, franck.routier@axege.com
Subject: Re: pg_restore : out of memory
In-Reply-To: <f966c2ee0812190000y698ddb74i7d886b492a01ca7@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox