When copying a large amount of data (around 9GB) from CSV file into table, I get following error:
ERROR: out of memory DETAIL: Cannot enlarge string buffer containing 1073741632 bytes by 349 more bytes. CONTEXT: COPY column_name line 13275136
A server (postgresql 10) has 8GB of memory and database has shared_buffers set to 2GB.
Can somebody suggest a solution, please. Or problem is instead in column_name length ( according to
CONTEXT: COPY column_name line 13275136 message)