Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We've noticed on our CentOS PostgreSQL database servers that every postgres process is no longer running at the default nice priority of '0'. They are running at a lower priority (2). Is Linux lowering the priority of these processes over time, or does a change in niceness have to be caused by a more manual process (renice, from within postgres, etc.)? My assumption was the latter.

Restarting PostgreSQL returns all 'postmaster' processes to the default nice value of '0'.

This is occuring on CentOS 5 with PostgreSQL 9.0

share|improve this question
    
Is it the PRiority or the NIce value that is changing? You are using both terms - they do not mean the same thing, and they are not interchangeable... –  voretaq7 Jan 18 '13 at 17:20
    
Indeed I did. I was primarily referring to the 'nice' value. However this post applies to both. 'priority' is 17 and 'nice' is 2. After restarting PostgreSQL 'priority' is 15 and 'nice' is 0. –  ahtanum214 Jan 20 '13 at 15:14
    
the key difference between the two is "priority" will change over time (the kernel scheduler determines that one and it changes based on a bunch of factors), but "nice" shouldn't change unless something actively renices the process - if your nice value is changing I'm stumped :-/ –  voretaq7 Jan 21 '13 at 1:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.