Re: problem with memory - Mailing list pgsql-hackers

From Tom Lane
Subject Re: problem with memory
Date
Msg-id 13165.1243353602@sss.pgh.pa.us
Whole thread Raw
In response to problem with memory  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: problem with memory  (Greg Stark <greg.stark@enterprisedb.com>)
List pgsql-hackers
Pavel Stehule <pavel.stehule@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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: PostgreSQL Developer meeting minutes up
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL Developer meeting minutes up