On 05/23/2018 04:36 PM, Ben Chobot wrote:
On May 7, 2018, at 11:50 PM, Ayappan P2 <ayappap2@xxxxxxxxxx
<mailto:ayappap2@xxxxxxxxxx>> wrote:
We are doing "renice" on the main Postgresql process to give higher
scheduling priority because other critical operations depends on the
database.
You are saying that the database processes take longer to relinquish
their resources and we won't achieve anything out of renice, So i
assume renice of the database processes is not at all required ?
Thanks
Ayappan P
Yes, if you make a db process nicer than the db takes longer to answer
your queries. If the goal is to keep the load down on the db, that is
usually going to be counterproductive.
Correct or in other words, the problem is bad provisioning. You need to
optimize your resources whether that be hardware/vm or code.
JD
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****
