we have dedicated PostgreSQL(9.0.4) sever (ubuntu 10.04.2LTS) with 2CPUs (8 cores total). On some queries postgres processes eat up all CPU's and we are unable to ssh to our server. I wonder if is where any possibility to dedicate one core for OS/system use?
You'll need to change the Postgres' process affinity.
First you'll need schedutils:
Then you can use
So you would ideally only dedicate 7 cores to Postgres, leaving 1 core for your system.