I would like to understand if increasing
work_mem does help improving the speed of the
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
COPY does not need a lot of memory.
There are two things to speed up
Remove any indexes and constraints on the table before you
COPY into it.
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.