Re: COPY FROM : out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY FROM : out of memory
Date: 2006-11-23 16:27:06
Message-ID: 14009.1164299226@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arnaud Lesauvage <thewild(at)freesurf(dot)fr> writes:
> When trying to import a 20M rows csv file into PostgreSQL, I
> get :

> ERROR: out of memory
> tat SQL :53200
> Dtail :Failed on request of size 1073741823.
> Contexte : COPY tmp, line 1

Can you put together a self-contained example? The reference to "line
1" suggests that you wouldn't need the whole 20M row file, just the
first few rows ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Ambrose 2006-11-23 16:32:30 A generic trigger to log chanes on database tables
Previous Message Ron Johnson 2006-11-23 16:23:55 Re: IS it a good practice to use SERIAL as Primary Key?