Koji vacuuming

Toshio Kuratomi a.badger at gmail.com
Wed Jan 30 23:16:17 UTC 2008


Kostas Georgiou wrote:
> 
> 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.
> 
Thanks Kostas!

I think I'll be setting this in the session whenever we run a vacuum 
until we have a chance to restart postgres with the new config.

-Toshio

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
URL: <http://listman.redhat.com/archives/fedora-infrastructure-list/attachments/20080130/7bbfdc79/attachment.sig>


More information about the Fedora-infrastructure-list mailing list