Re: Suspending postgresql during heavy load

The Doctor <doctor(at)doctor(dot)nl2k(dot)ab(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800