PostgreSQL 9.2.1 out of memory on \COPY

Question

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

in /boot/loader.conf

When trying to populate one of my tables;

CREATE TABLE fb_user (
    id BIGINT NOT NULL,
    name TEXT,
    category VARCHAR(100));

With \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

Yes, fb_user.csv is quite large (1.6G and 47'361'855 lines) but should not the \copy function handle that?