controlling postgres I/O and CPU processing

[Nirmal Ferrer]

Hi,
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.
Thanks,
Nirmal R.

[michaelb]

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.