Re: [GENERAL] COPY FROM : out of memory

2006-11-24 Thread Arnaud Lesauvage
Alvaro Herrera a écrit : Arnaud Lesauvage wrote: Martijn van Oosterhout a écrit : >On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote: >>Arnaud Lesauvage <[EMAIL PROTECTED]> writes: >>> When trying to import a 20M rows csv file into PostgreSQL, I >>> get : >> >>> ERROR: out of memory >>>

Re: [GENERAL] COPY FROM : out of memory

2006-11-23 Thread Alvaro Herrera
Arnaud Lesauvage wrote: > Martijn van Oosterhout a écrit : > >On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote: > >>Arnaud Lesauvage <[EMAIL PROTECTED]> writes: > >>> When trying to import a 20M rows csv file into PostgreSQL, I > >>> get : > >> > >>> ERROR: out of memory > >>> État SQL :53

Re: [GENERAL] COPY FROM : out of memory

2006-11-23 Thread Arnaud Lesauvage
Martijn van Oosterhout a écrit : On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote: Arnaud Lesauvage <[EMAIL PROTECTED]> 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 107374182

Re: [GENERAL] COPY FROM : out of memory

2006-11-23 Thread Terry Fielder
Tom Lane wrote: Arnaud Lesauvage <[EMAIL PROTECTED]> 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-containe

Re: [GENERAL] COPY FROM : out of memory

2006-11-23 Thread Martijn van Oosterhout
On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote: > Arnaud Lesauvage <[EMAIL PROTECTED]> 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

Re: [GENERAL] COPY FROM : out of memory

2006-11-23 Thread Tom Lane
Arnaud Lesauvage <[EMAIL PROTECTED]> 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

[GENERAL] COPY FROM : out of memory

2006-11-23 Thread Arnaud Lesauvage
Hi list ! 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 The table has no index, no trigger, ... : CREATE TABLE tmp ( c1 bigint, c2 character varying, c3 c