Re: BUG #2958: ERROR: 53200: out of memory

On windows, this could be the cause:

I cannot run with more than about 125 connections at once, despite
having capable hardware:
http://www.postgresql.org/docs/faqs.FAQ_windows.html#4.4

"Out of memory" error message appears when you have a large number of
programs running
http://support.microsoft.com/?scid=kb;en-us;126962&x=9&y=11
http://support.microsoft.com/?scid=kb;en-us;184802&x=7&y=13

Unexpected behavior occurs when you run many processes on a computer
that is running SQL Server:
http://support.microsoft.com/?scid=kb;en-us;824422&x=5&y=18


> The following bug has been logged online:
>
> Bug reference:      2958
> Logged by:          Anton Andreev
> Email address:      fn30762(at)fmi(dot)uni-sofia(dot)bg
> PostgreSQL version: 8.2
> Operating system:   Windows Server 2003 32bit
> Description:        ERROR: 53200: out of memory
> Details:
>
> I have this error and some other odd behavior as the postgresql does not
> want to start without restart of the machine. I am using a Virtual Private
> Server with 320MB RAM, but I do not think the memory is the problem.
>
> Someone suggested that this might help:
> SET enable_hashagg = false;
> Should I use it?
>
> This problem dates from version 7.4???