From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Linux server connection process consumes all memory |
Date: | 2011-12-05 16:23:55 |
Message-ID: | 201112050823.55438.ahodgson@simkin.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2011-12-05 17:16:44 | Re: prepared statements & functions |
Previous Message | José Fermín Francisco Ferreras | 2011-12-05 12:38:30 | RE: problema con comando \c en el psql |