I'm running a postgreSQL 9.2.1 installation in a FreeBSD 9.0 Jail with default settings.
I've configured loader.conf according to this post: http://forums.freebsd.org/showpost.php?p=64521&postcount=2 i.e.
kern.ipc.semmni=40 kern.ipc.semmns=240 kern.ipc.seumr=40 kern.ipc.semmnu=120
When trying to populate one of my tables;
CREATE TABLE fb_user ( id BIGINT NOT NULL, name TEXT, category VARCHAR(100));
\COPY fb_user(id, name, category) from 'fb_user.csv' with delimiter ',' CSV quote '"';
It runs for a few seconds and then prints:
ERROR: out of memory DETAIL: Cannot enlarge string buffer containing 1073741800 bytes by 40 more bytes. CONTEXT: COPY fb_user, line 1
fb_user.csv is quite large (1.6G and 47'361'855 lines) but should not the \copy function handle that?