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 <tgl@sss.pgh.pa.us> wrote:
> 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
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers