Re: Suspending postgresql during heavy load

First thing is why do you want to suspend Postgres session or stop the
database under heavy load ?

I suspect either your hardware is not sufficient for heavy load
transactions OR your configuration parameters are not set properly to
handle heavy load transactions.

If your hardware is not sufficient the you should upgrade your hardware
ASAP which will give you better performance OR if you have sufficient
hardware you should change some parameters in postgresql.conf for better
performance.

I suggest you should not Suspending/Shutdown server for your convenience
which is not good choice for loosing on-going transactions .
--

Thanks & Regards,

Harshad Adalkonda
Database Administrator

<www.shreeyansh.com>

www.shreeyansh.com

On Tue, Oct 7, 2014 at 8:37 PM, The Doctor <doctor(at)doctor(dot)nl2k(dot)ab(dot)ca> wrote:

> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>