From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Markus <t.markus@proventis.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: out of memory in backup and restore
Date: Fri, 15 Dec 2006 10:44:34 -0500
Message-ID: <9065.1166197474@sss.pgh.pa.us> (raw)
In-Reply-To: <45828ED6.9020501@proventis.net>
References: <45826AD7.7050005@proventis.net>
<bf54be870612150319x90ea963hf2b0c3443139ad3e@mail.gmail.com>
<45828ED6.9020501@proventis.net>
Thomas Markus <t.markus@proventis.net> writes:
> logfile content see http://www.rafb.net/paste/results/cvD7uk33.html
It looks to me like you must have individual rows whose COPY
representation requires more than half a gigabyte (maybe much more,
but at least that) and the system cannot allocate enough buffer space.
It could be that this is a symptom of corrupted data, if you're certain
that there shouldn't be any such rows in the table.
> kernel is 2.6.15-1-em64t-p4-smp, pg version is 8.1.0 32bit
You really need a 64-bit PG build if you want to push
multi-hundred-megabyte field values around --- otherwise there's just
not enough headroom in the process address space. (Something newer than
8.1.0 would be a good idea too.)
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, t.markus@proventis.net
Subject: Re: out of memory in backup and restore
In-Reply-To: <9065.1166197474@sss.pgh.pa.us>
References: <45826AD7.7050005@proventis.net> <bf54be870612150319x90ea963hf2b0c3443139ad3e@mail.gmail.com> <45828ED6.9020501@proventis.net> <9065.1166197474@sss.pgh.pa.us>
* 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