From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-novice@postgresql.org
Subject: Re: Linux server connection process consumes all memory
Date: Mon, 5 Dec 2011 08:23:55 -0800
Message-ID: <201112050823.55438.ahodgson@simkin.ca> (raw)
In-Reply-To: <4EDC9FE0.8030506@anatec.com>
References: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A09@appserver.anatec.local>
<23418.1323016204@sss.pgh.pa.us>
<4EDC9FE0.8030506@anatec.com>
On Monday, December 05, 2011 02:41:36 AM Ioannis Anagnostopoulos wrote:
> The top below show the "updated" query running. This time the load is at
> 8.9% right at the end of the run. Nowhere near the 96% but please
> keep in mind that this happened when I reduced to iterations to 55.000.
>
Reduce it to 3 or 4. Turn on statement logging per Tom's request. Empty the
logs. Restart PostgreSQL. Do one run. Let's see everything PostgreSQL is
actually getting from the client.
Also ... please don't top-post.
> On 04/12/2011 16:30, Tom Lane wrote:
> >
> > I don't know much of anything about VB, but I am filled with suspicion
> > that something in the VB infrastructure you're using is not doing what
> > you think. In particular, I'm betting that repeated executions of this
> > code are in fact generating new prepared statements without deallocating
> > old ones. You could investigate that theory by setting log_statement =
> > all in the server configuration and then watching the server log to see
> > exactly what SQL commands are actually getting sent.
> >
> > regards, tom lane
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: <201112050823.55438.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