| From: | Terry Fielder <terry(at)ashtonwoodshomes(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: COPY FROM : out of memory |
| Date: | 2006-11-23 16:50:58 |
| Message-ID: | 4565D172.5070603@ashtonwoodshomes.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> 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
>> Détail :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 ...
>
Unless its not seeing the end of the first record AS the end of the
first record, and hence seeing the whole file as 1 record.
Terry
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2006-11-23 16:52:09 | Re: A generic trigger to log chanes on database tables |
| Previous Message | Martijn van Oosterhout | 2006-11-23 16:50:45 | Re: COPY FROM : out of memory |