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