Re: problem with memory

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