Postgresql many processes

Question

I have Postgresql installed in a machine where runs a system, and throughout the day there are several processes with postgres.exe and consumes machine resources. At times it has more than 100 instances of these processes.

Any suggestions?

Version: Postgres 9.2

Answer 1

In 9.2 I do not know any way. In 9.4 onwards you can limit the maximum number of active processes with the configuration directive max_worker_processes (documentation). This can obviously limit the ability to respond to requests, if you are creating so many it is because you need it. But there are also cases that can improve the functioning. Only testing on real loads to see.

Complete documentation of possible settings.