The link was to the memory context dump. The only suspicious context I spotted was 300mb in MessageContext. What is lc_messages and lc_ctype set to on this machine? Were the latest round of infinite recursion in the character conversion routines in 8.3.7?

--
Greg


On 26 May 2009, at 17:00, Tom Lane <t...@sss.pgh.pa.us> wrote:

Pavel Stehule <pavel.steh...@gmail.com> writes:
one czech PostgreSQL user reports problem with memory - probable memleak?
Is possible to diagnose some from log?

If he's getting an actual "out of memory" error, let's see the memory
context map that gets dumped to the server log (or more specifically,
to stderr).

Server 8G RAM,  32b Debian Etch.
shared_buffers = 324000 # min 16 or max_connections*2, 8KB each

Although you may have told us enough right here.  2.5GB of shared
buffers in a 4GB address space (with probably only 3GB available to the
application) isn't a very sane choice.  Back that off or run 64-bit.

           regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to