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 .
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 .
On Tue, Oct 7, 2014 at 8:37 PM, The Doctor <doctor@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
