The Doctor <doctor@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
