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