Re: "Out of memory" errors..

>
> Vacuum memory usage is tuned by the "maintenance_work_mem" parameter. I
> suggest you look at
> http://www.postgresql.org/docs/8.2/static/runtime-config-resource.html and
> http://www.postgresql.org/docs/8.2/static/kernel-resources.html#AEN19338.



Thanks Sander, I've read so many of these pages that my head spins. I
notice maintenance_work_mem shows clearly it will affect VACUUM
performance. But the other parameters are less clear, and do not
clearly state if they will become active only when I restart the
postmaster.