Re: Backend memory growing too much

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: ohp@pyrenet.fr
Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
Date: 2007-07-17T15:13:38Z
Lists: pgsql-hackers
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