Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XbWMT-0006tx-4E for pgsql-admin@arkaria.postgresql.org; Tue, 07 Oct 2014 15:07:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XbWMS-0002Po-JK for pgsql-admin@arkaria.postgresql.org; Tue, 07 Oct 2014 15:07:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XbWMQ-0002N9-VZ for pgsql-admin@postgresql.org; Tue, 07 Oct 2014 15:07:35 +0000 Received: from doctor.nl2k.ab.ca ([204.209.81.1]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XbWMJ-0006tZ-5L for pgsql-admin@postgresql.org; Tue, 07 Oct 2014 15:07:33 +0000 Received: from localhost.nl2k.ab.ca ([127.0.0.1] helo=localhost ident=doctor) by doctor.nl2k.ab.ca with esmtp (Exim 4.84) (envelope-from ) id 1XbWM7-000093-Hq; Tue, 07 Oct 2014 09:07:21 -0600 Date: Tue, 7 Oct 2014 09:07:13 -0600 From: The Doctor To: pgsql-admin@postgresql.org Subject: Suspending postgresql during heavy load Message-ID: <20141007150713.GA29776@doctor.nl2k.ab.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Question is their a way to suspend PostGres during a heavy average load session? I would like to suspend Postgresql transaction on a load average higher then a load average of 5. -- Member - Liberal International This is doctor@@nl2k.ab.ca Ici doctor@@nl2k.ab.ca God,Queen and country!Never Satan President Republic!Beware AntiChrist rising! http://www.fullyfollow.me/rootnl2k Look at Psalms 14 and 53 on Atheism Truth is a gaffe to liars. -unknown -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin