Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XbZ1c-00058f-Qa for pgsql-admin@arkaria.postgresql.org; Tue, 07 Oct 2014 17:58:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XbZ1b-0001aq-Fh for pgsql-admin@arkaria.postgresql.org; Tue, 07 Oct 2014 17:58:15 +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 1XbZ1M-0001Dl-KS for pgsql-admin@postgresql.org; Tue, 07 Oct 2014 17:58:00 +0000 Received: from resqmta-ch2-05v.sys.comcast.net ([2001:558:fe21:29:69:252:207:37]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XbZ1H-0002RS-2G for pgsql-admin@postgresql.org; Tue, 07 Oct 2014 17:57:58 +0000 Received: from resomta-ch2-12v.sys.comcast.net ([69.252.207.108]) by resqmta-ch2-05v.sys.comcast.net with comcast id 0HxT1p0032LrikM01HxqFD; Tue, 07 Oct 2014 17:57:50 +0000 Received: from jerry.enova.com ([38.98.177.132]) by resomta-ch2-12v.sys.comcast.net with comcast id 0Hxf1p0062rmZlA01HxhvH; Tue, 07 Oct 2014 17:57:48 +0000 Received: by jerry.enova.com (Postfix, from userid 1001) id 813D17401F1; Tue, 7 Oct 2014 12:32:39 -0500 (CDT) From: Jerry Sievers To: The Doctor Cc: pgsql-admin@postgresql.org Subject: Re: Suspending postgresql during heavy load References: <20141007150713.GA29776@doctor.nl2k.ab.ca> Date: Tue, 07 Oct 2014 12:32:39 -0500 In-Reply-To: <20141007150713.GA29776@doctor.nl2k.ab.ca> (The Doctor's message of "Tue, 7 Oct 2014 09:07:13 -0600") Message-ID: <86zjd7zsy0.fsf@jerry.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20140121; t=1412704670; bh=ezWishXndj5FGHiAaBbdqlsPWmUIa+xOBROFVR11TQg=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=PoH+O7z9IEgtTjkRZhobwBIT+xgETxrjXbqd5BYPps81S5hcOK3b69hARVrF6oMwK TsK84XzFzF6bA2FR5fcGN/vyJd4M8NmjGi7ZeYiXOzIpcqCY1hru9UHgE8TNx6sHHd AOwJLYBcU1OgaHysPSOEreNUjLcZM4BWlzD86t7LHpVi9MIe7OvpJHZNrH7jJrt+vT xLmet3/Qu6ZkXwQpJ6slTnyjJgtDLLRPk1omajRe2gogVvTC6HTEqLmRjVEmadFU5L PVztz0neidcjsHezItTzyFWLWcagWNfydAqchnMp7HE0JRhmx75trMUEnXVTi4T1Q1 ALgMzZ9FNemog== 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 The Doctor writes: > 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. You aren't being very clear if you want to suspend a single backend or the whole instance (which I'm not sure if feasible). Individual backends will pause/continue via SIGSTOP SIGCONT. I've done this under various interesting diagnostic conditions and did not observe ill effects but there might certainly be some, especially if you left the session paused for an extended period. HTH > > -- > 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 -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin