Arnaud Lesauvage <thewild@xxxxxxxxxxx> 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 ... regards, tom lane