August 26th, 2013, 01:16 PM
Heavy context switching causing high cpu ?
I am using Postgres Sql 9.2 on a windows 2008 server that has 12 cores and 48GB RAM.
When running a simple performance test with 60 users where each user adds a person (a request to a webservice), db cpu utilization is at 18%. There is no other activity on this server during this test. Person Table has only about 3 or 4 columns and this table is not indexed.
No single process seems to be utilizing a lot of the CPU. I find a lot of context switching taking place (about 16,000/sec).
I am using defaults settings for PostgresSql mostly. The only settings I changes were maxConnections (which is 300 now) and Shared Buffers(which is 512MB now).
Is there any configuration setting that needs to be changed to reduce the number of context switches ?