Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 18FA39ED582 for ; Wed, 7 Dec 2011 16:26:31 -0400 (AST) Received: from zeus.simkin.ca ([72.51.27.124]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RYO4T-0004jt-Po for pgsql-novice@postgresql.org; Wed, 07 Dec 2011 20:26:31 +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 AFA92270971 for ; Wed, 7 Dec 2011 12:26:15 -0800 (PST) From: Alan Hodgson To: pgsql-novice@postgresql.org Subject: Re: Linux server connection process consumes all memory Date: Wed, 7 Dec 2011 12:26:13 -0800 User-Agent: KMail/1.13.7 (Linux/3.0.6-gentoo; KDE/4.6.5; x86_64; ; ) References: <4EDF589D.7060003@anatec.com> In-Reply-To: <4EDF589D.7060003@anatec.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Message-Id: <201112071226.13291.ahodgson@simkin.ca> X-Pg-Spam-Score: -3.1 (---) X-Archive-Number: 201112/41 X-Sequence-Number: 25807 On Wednesday, December 07, 2011 04:14:21 AM Ioannis Anagnostopoulos wrote: >. So what I am not sure > still is what will happen if I execute 22million times non-prepared > statements, will it crash or will it survive since I removed the buggy > "prepared" that were nested. PostgreSQL? It'll happily serve up queries for years if you aren't stacking up prepared query objects in your session :p