Re: Backend memory growing too much

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ohp(at)pyrenet(dot)fr
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Backend memory growing too much
Date: 2007-07-17 15:13:38
Message-ID: 23541.1184685218@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ohp(at)pyrenet(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-07-17 15:18:49 Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)
Previous Message Brendan Jurd 2007-07-17 14:47:36 Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)