Postgres Pro
Downloads
Home   >   mailing lists

Re: Backend memory growing too much - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Backend memory growing too much
Date
Msg-id 23541.1184685218@sss.pgh.pa.us
Whole thread Raw
In response to Backend memory growing too much  (ohp@pyrenet.fr)
List pgsql-hackers
Tree view 
ohp@pyrenet.fr writes:
> I don't know much about DBI/DBD but I know sqlgrey uses a lot of
> prepare/prepare_cached statements.

Well, those aren't exactly free.

Possibly you could learn something about it by attaching to one of
these backends with gdb and executing
call MemoryContextStats(TopMemoryContext)

This will dump a memory map to stderr.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Brendan Jurd"
Date:
Subject: Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)
Next
From: Tom Lane
Date:
Subject: Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)