From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-novice@postgresql.org
Subject: Re: Linux server connection process consumes all memory
Date: Sat, 3 Dec 2011 22:17:46 -0800
Message-ID: <201112032217.46928.ahodgson@simkin.ca> (raw)
In-Reply-To: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A0B@appserver.anatec.local>
References: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A09@appserver.anatec.local>
<201112031558.38312.ahodgson@simkin.ca>
<B56C2BFC6806BE4A9C86ADDDD269933A6E8A0B@appserver.anatec.local>
On Saturday, December 03, 2011 05:43:30 PM Ioannis Anagnostopoulos wrote:
> Hi thank you for the answer, I am referring to the postgres process
> on the Linux server corresponding to the connection I have established.
> After doing a TOP you may see quite a few postgres processes. One of them
> belongs to the connection established by the client application. It is this
> process that grows consuming memory.
>
Tom has posted a request for some follow-up information that might help track
this down.
One thought, though, is it possible you are creating a new prepared statement
for each query instead of re-using one? And then not relelasing them? I did a
quick test and creating millions of prepared statements will chew up a lot of
memory pretty quick in the backend.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-novice@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: Linux server connection process consumes all memory
In-Reply-To: <201112032217.46928.ahodgson@simkin.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox