From: | "Ioannis Anagnostopoulos" <ioannis(at)anatec(dot)com> |
---|---|
To: | "Alan Hodgson" <ahodgson(at)simkin(dot)ca>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Linux server connection process consumes all memory |
Date: | 2011-12-04 01:43:30 |
Message-ID: | B56C2BFC6806BE4A9C86ADDDD269933A6E8A0B@appserver.anatec.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
Kind regards
Yiannis
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org on behalf of Alan Hodgson
Sent: Sat 03/12/2011 23:58
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Linux server connection process consumes all memory
On Saturday, December 03, 2011 02:45:11 PM Ioannis Anagnostopoulos wrote:
> When I start iterating executing the select command as time goes by the
> memory footprint of the process grows bigger and bigger. Sooner or later
> the server either collapses or becomes unworkable as the physical memory
It's not clear from this what process is continuing to grow. Is it the
PostgreSQL server process? Or your client process?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-12-04 04:45:27 | Re: Linux server connection process consumes all memory |
Previous Message | Alan Hodgson | 2011-12-03 23:58:38 | Re: Linux server connection process consumes all memory |