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