Re: COPY FROM : out of memory

On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote:
> Arnaud Lesauvage <thewild@freesurf.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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.