Re: Linux server connection process consumes all memory

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

In response to

Browse pgsql-novice by date

  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