Re: Out of memory on vacuum analyze

On Feb 19, 2007, at 1:19 PM, Jeff Davis wrote:
> You told PostgreSQL that you have 900MB available for
> maintenance_work_mem, but your OS is denying the request. Try  
> *lowering*
> that setting to something that your OS will allow. That seems like an
> awfully high setting to me.

900MB isn't that unreasonable if you're building indexes on a restore  
or something similar. I have run into issues when trying to set it  
much over 1G, though... on various OSes and platforms.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)