Re: BUG #2958: ERROR: 53200: out of memory - Mailing list pgsql-bugs

From Jorge Flores
Subject Re: BUG #2958: ERROR: 53200: out of memory
Date
Msg-id 2788689d0902010428g77150262v7d0a1b580db84336@mail.gmail.com
Whole thread Raw
In response to BUG #2958: ERROR: 53200: out of memory  ("Anton Andreev" <fn30762@fmi.uni-sofia.bg>)
List pgsql-bugs
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???

pgsql-bugs by date:

Previous
From: "Martin Blazek"
Date:
Subject: BUG #4629: PL/pgSQL issue
Next
From: Stefan Kaltenbrunner
Date:
Subject: backend crash on CREATE OR REPLACE of a C-function on Linux