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@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
