From: Jerry Sievers <gsievers19@comcast.net>
To: The Doctor <doctor@doctor.nl2k.ab.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: Suspending postgresql during heavy load
Date: Tue, 07 Oct 2014 12:32:39 -0500
Message-ID: <86zjd7zsy0.fsf@jerry.enova.com> (raw)
In-Reply-To: <20141007150713.GA29776@doctor.nl2k.ab.ca>
References: <20141007150713.GA29776@doctor.nl2k.ab.ca>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
The Doctor <doctor@doctor.nl2k.ab.ca> 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
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-admin@postgresql.org
Cc: gsievers19@comcast.net, doctor@doctor.nl2k.ab.ca
Subject: Re: Suspending postgresql during heavy load
In-Reply-To: <86zjd7zsy0.fsf@jerry.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox