postgres.exe: why multiple postgres.exe for a single database connection? [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it&#开发者_Go百科39;s on-topic for Stack Overflow.

Closed 11 years ago.

Improve this question

I'm using postgresql, and when I start a database connection (using PQconnectdb) I see two new postgres.exe which appear. In some of my tools, I see three new postgres.exe which appear.

I've read the multiple postgres.exe is normal, as it uses a multi-process architecture instead of a multi-threaded one, but I'm wondering why there are 2 (or 3) of them that start up when I connect to the database.

---

On linux, I see 3 processes:

1. postgres: logger process
2. postgres: writer process
3. postgres: stats collector process

There's also an additional process for each open connection. Autovacuum will probably similarly occupy one thread per worker, while working.

I imagine the situation is similar in windows.