pg_restore : out of memory

From: Franck Routier <franck(dot)routier(at)axege(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: pg_restore : out of memory
Date: 2008-12-04 14:08:35
Message-ID: 1228399715.16894.22.camel@franck-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)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...

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Albe Laurenz 2008-12-05 08:24:10 Re: Trigger function, bad performance
Previous Message Rogatzki Rainer 2008-12-04 13:32:44 Trigger function, bad performance