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
Attachment:
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Fedora-infrastructure-list mailing list Fedora-infrastructure-list@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list
