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