Koji vacuuming

Kostas Georgiou k.georgiou at imperial.ac.uk
Wed Jan 30 04:00:32 UTC 2008


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




More information about the infrastructure mailing list