agora inbox for pgsql-novice@postgresql.org
help / color / mirror / Atom feedFrom: Jean-Yves F. Barbier <12ukwn@gmail.com>
To: pgsql-novice@postgresql.org
Subject: Re: Linux server connection process consumes all memory
Date: Wed, 7 Dec 2011 21:40:23 +0100
Message-ID: <20111207214023.4cd06deb@anubis.defcon1> (raw)
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>
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.
view thread (22+ messages)
Message-ID: <20111207214023.4cd06deb@anubis.defcon1>
Permalink: ../20111207214023.4cd06deb@anubis.defcon1/
Also on: postgresql.org/message-id/20111207214023.4cd06deb@anubis.defcon1
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-novice@postgresql.org
Cc: 12ukwn@gmail.com
Subject: Re: Linux server connection process consumes all memory
In-Reply-To: <20111207214023.4cd06deb@anubis.defcon1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox