| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| 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:45 |
| Message-ID: | 20061123165045.GB14956@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Nov 23, 2006 at 11:27:06AM -0500, 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 ...
Maybe it's a line termination problem?
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Fielder | 2006-11-23 16:50:58 | Re: COPY FROM : out of memory |
| Previous Message | Martijn van Oosterhout | 2006-11-23 16:49:10 | Re: IS it a good practice to use SERIAL as Primary Key? |