Kostas Georgiou wrote:
You can also change it for a user or a database with:
ALTER DATABASE koji SET maintenance_work_mem TO 1048576;
ALTER USER koji SET maintenance_work_mem TO 1048576;
The per session setting should be enough though if you
only need the extra memory for the vacuum.
Thanks Kostas!
I think I'll be setting this in the session whenever we run a vacuum
until we have a chance to restart postgres with the new config.
-Toshio