Postgres Pro
Downloads
Home   >   mailing lists

Copy command-Out of memory error - Mailing list pgsql-novice

From nipuna
Subject Copy command-Out of memory error
Date
Msg-id jtxnpbasqi9fnujfnrrccdm5.1349804107889@email.android.com
Whole thread Raw
Responses Re: Copy command-Out of memory error
List pgsql-novice
Tree view
Hi, 
 I am trying to copy a 13G file to postgres db using the 'copy from' command on PGSQL 8.4. After loading 8 million records I got the below error .

ERROR: out of memory

DETAIL: Cannot enlarge string buffer containing 1073726116 bytes by 65536 more bytes.

CONTEXT: COPY teststorage, line 8479575
  In my table I do not have foreign keys or triggers. I simply want to load the file to database. I was able to use the copy from command with 10000 records , jus to make sure it works.

please advice 

Sent via the Samsung Galaxy S™III, an AT&T 4G LTE smartphone

pgsql-novice by date:

Previous
From: sravanch
Date:
Subject: Guidance needed to be a postgreSQL DBA
Next
From: Tom Lane
Date:
Subject: Re: Copy command-Out of memory error