On Tue, Jan 29, 2008 at 07:18:53PM -0800, Toshio Kuratomi wrote: > Kostas Georgiou wrote: >> On Tue, Jan 29, 2008 at 01:41:52PM -0800, Toshio Kuratomi wrote: >> >>> Devrim suggested we increase maintenance_work_mem to 1GB which I've done >>> in the configs. That won't go live until we have an opportunity to >>> restart the postgres server. >> >> Any reason not to change the setting on the fly? > No reason but ignorance :-) > > Can you tell me how? All I've been able to find are ways to change the > value per-session. 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. Kostas _______________________________________________ Fedora-infrastructure-list mailing list Fedora-infrastructure-list@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list
