By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,388 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

controlling postgres I/O and CPU processing

P: 2
we see a lot of I/O access and CPU usage when running postgres (8.2.3) on windows. This happens even with auto vaccuum off and all stats turned off. Is there a way to control this? For instance I remember seeing some option such as /numproc=1 in some forum but, I do not see that as an option for 8.2.3. Can you please suggest an equivalent to tell postgres to spawn threads instead of processes? Any help would be appreciated.
Nirmal R.
Apr 4 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 534
Postgresql in a multi-process server, you cannot tell it to use threads...
The closest control I can think of is max_ connections, which imposes limit on number of children spawned by postmaster.

Take a look at Resource Consumption and Connections

A high utilization of CPU can be due to processing of compuiting-hungry queries.
Apr 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.