Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id EDF3D682EAF
	for <pgsql-novice@postgresql.org>; Sat,  3 Dec 2011 19:58:53 -0400 (AST)
Received: from zeus.simkin.ca ([72.51.27.124])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ahodgson@simkin.ca>) id 1RWzTp-0004Lc-UK
	for pgsql-novice@postgresql.org; Sat, 03 Dec 2011 23:58:54 +0000
Received: from skynet.simkin.ca (vpn.reinvent.com [72.51.27.50])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by zeus.simkin.ca (Postfix) with ESMTPSA id A34A027031E
	for <pgsql-novice@postgresql.org>; Sat,  3 Dec 2011 15:58:40 -0800 (PST)
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 15:58:38 -0800
User-Agent: KMail/1.13.7 (Linux/3.0.6-gentoo; KDE/4.6.5; x86_64; ; )
References: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A09@appserver.anatec.local>
In-Reply-To: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A09@appserver.anatec.local>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201112031558.38312.ahodgson@simkin.ca>
X-Pg-Spam-Score: -3.1 (---)
X-Archive-Number: 201112/6
X-Sequence-Number: 25772

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?