Date: Wed, 7 Dec 2011 21:40:23 +0100
From: "Jean-Yves F. Barbier" <12ukwn@gmail.com>
To: pgsql-novice@postgresql.org
Subject: Re: Linux server connection process consumes all memory
Message-ID: <20111207214023.4cd06deb@anubis.defcon1>
In-Reply-To: <4EDF589D.7060003@anatec.com>
References: <B56C2BFC6806BE4A9C86ADDDD269933A6E8A09@appserver.anatec.local>
	<11644.1322973927@sss.pgh.pa.us>
	<B56C2BFC6806BE4A9C86ADDDD269933A6E8A0C@appserver.anatec.local>
	<23418.1323016204@sss.pgh.pa.us> <4EDC9FE0.8030506@anatec.com>
	<CAHyXU0wM_u5yrWVc=Lak6U1WxKJvBR0uZLEFO=djtiaU=htpjQ@mail.gmail.com>
	<4EDDDCEF.5080903@anatec.com>
	<CAHyXU0z+xjcW-7nDj4hpZEo2pX7MQajeZ_NYVjiMpF4RoQK5TA@mail.gmail.com>
	<22700.1323191446@sss.pgh.pa.us> <4EDF30D6.20705@anatec.com>
	<CAA2qdGUQx8ZpaHbCwre0yMEmOX-OnA4BVm86yEQO2OT7O37AMA@mail.gmail.com>
	<4EDF589D.7060003@anatec.com>
Organization: Anyone, anywhere, BUT in banana republik of france
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

On Wed, 07 Dec 2011 12:14:21 +0000
Ioannis Anagnostopoulos <ioannis@anatec.com> 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.

It would take "some" time but wouldn't crash at all, but avoid to do
this kinda exercise daily on a SSD, it wouldn't like.

Think about Pg as the same thing as oracle, except it doesn't try to
hijack your assets each time you have a question to ask about it ;)

-- 
If you are a police dog, where's your badge?
-- Question James Thurber used to drive his German Shepherd crazy.