arsham
3/4/2016 - 5:19 PM

If you are going to build a large index or do some other large query that can benefit from access to more RAM, set work_mem larger for your

If you are going to build a large index or do some other large query that can benefit from access to more RAM, set work_mem larger for your session

Build a large index on postgres
content_copyfile_download
set work_mem = '56GB';
commit;
-- Do your work here.
-- Then be a good neighbour.
set work_mem = default;
commit;