PostgreSQL many processes

1

I have PostgreSQL installed on a machine where a system runs, and throughout the day several processes with postgres.exe appear and consume machine resources. In moments it has more than 100 instances of these processes.

Any suggestions?

Version: Postgres 9.2

    
asked by anonymous 09.06.2016 / 15:39

1 answer

3

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

Full documentation of possible configurations .

    
09.06.2016 / 16:03