Message-ID: <4E5C4CF7.8020302@gmail.com>
Date: Tue, 30 Aug 2011 10:37:43 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:6.0) Gecko/20110812 Thunderbird/6.0
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: plsql gets "out of memory"
References: <4E5B8FF7.4040007@gmail.com>
	<CAOR=d=1bAp7+tLo9J3UjWue4XCRiHw0PwWC0btcDUjUauWQbzg@mail.gmail.com>
In-Reply-To: 
 <CAOR=d=1bAp7+tLo9J3UjWue4XCRiHw0PwWC0btcDUjUauWQbzg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Yes, seems so. I separated one of the tables having the problem and did 
a test. First, loaded it with original file and saw the same: invalid 
command then follows "out of memory". After I fixed those escape 
characters, the table could be loaded successfully.

于 2011/8/30 10:14, Scott Marlowe 写道:
> 2011/8/29 Rural Hunter<ruralhunter@gmail.com>:
>> Hi all,
>> I'm a newbie here. I'm trying to test pgsql with my mysql data. If the
>> performance is good, I will migrate from mysql to pgsql.
>> I installed pgsql 9.1rc on my Ubuntu server. I'm trying to import a large
>> sql file dumped from mysql into pgsql with 'plsql -f'. The file is around
>> 30G with bulk insert commands in it. It rans several hours and then aborted
>> with an "out of memory" error. This is the tail of the log I got:
>> INSERT 0 280
>> INSERT 0 248
>> INSERT 0 210
>> INSERT 0 199
>> invalid command \n
>> out of memory
> I'd look at what's leading to the invalid command \n up there.  I
> doubt the out of memory is more than a symptom from that.  I.e. some
> part of your inserts are improperly formatted and the machine is then
> trying to insert a row with what it thinks is a column of several
> gigabytes.
>