Improve speed of COPY COMMAND in postgres
No, COPY does not need a lot of memory.

There are two things to speed up COPY:


Remove any indexes and constraints on the table before you COPY into it.
Increase max_wal_size so that you don't get more checkpoints than necessary.

Of course, if you COPY into an UNLOGGED table, it will be even faster.