Обсуждение: BUG #2958: ERROR: 53200: out of memory
The following bug has been logged online: Bug reference: 2958 Logged by: Anton Andreev Email address: fn30762@fmi.uni-sofia.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???
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???