Re: Suspending postgresql during heavy load - Mailing list pgsql-admin

From Shreeyansh dba
Subject Re: Suspending postgresql during heavy load
Date
Msg-id CAGDYbUNhUyrUkiBsk0a9vKgz_YqMxWyoN1q+x+k0WB1SBdp3fQ@mail.gmail.com
Whole thread Raw
In response to Suspending postgresql during heavy load  (The Doctor <doctor@doctor.nl2k.ab.ca>)
List pgsql-admin
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


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

pgsql-admin by date:

Previous
From: jayknowsunix@gmail.com
Date:
Subject: Re: Error messages in a hot standby server's logfiles
Next
From: John Scalia
Date:
Subject: Restart or reload after changing the archive_command