Re: Linux server connection process consumes all memory - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: Linux server connection process consumes all memory
Date
Msg-id 20111207214023.4cd06deb@anubis.defcon1
Whole thread Raw
In response to Re: Linux server connection process consumes all memory  (Ioannis Anagnostopoulos <ioannis@anatec.com>)
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Linux server connection process consumes all memory
Next
From: Jude Lucien
Date:
Subject: Basic Query Question