Re: COPY FROM : out of memory
От
Martijn van Oosterhout
Тема
Re: COPY FROM : out of memory
Дата
Msg-id
20061123165045.GB14956@svana.org
Ответ на
Re: COPY FROM : out of memory (Tom Lane)
Список
Дерево обсуждения
COPY FROM : out of memory Arnaud Lesauvage <thewild@freesurf.fr>
Re: COPY FROM : out of memory Tom Lane <tgl@sss.pgh.pa.us>
Re: COPY FROM : out of memory Martijn van Oosterhout <kleptog@svana.org>
Re: COPY FROM : out of memory Arnaud Lesauvage <thewild@freesurf.fr>
Re: COPY FROM : out of memory Alvaro Herrera <alvherre@commandprompt.com>
Re: COPY FROM : out of memory Arnaud Lesauvage <thewild@freesurf.fr>
Re: COPY FROM : out of memory Terry Fielder <terry@ashtonwoodshomes.com>
Postgres scalability and performance on windows "Gopal" <gopal@getmapping.com>
Re: Postgres scalability and performance on windows Bill Moran <wmoran@collaborativefusion.com>
Re: Postgres scalability and performance on windows "Mark Cave-Ayland" <mark.cave-ayland@ilande.co.uk>
Re: Postgres scalability and performance on windows "Merlin Moncure" <mmoncure@gmail.com>
On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote: > Arnaud Lesauvage 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 http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
В списке pgsql-general по дате отправления
От: Martijn van Oosterhout
Дата:
