Who has any documents that about PostgreSQL background processes?
I'd like to learn the detail about these background processes:
- postgres: logger process
- postgres: writer process
- postgres: wal writer process
- postgres: autovacuum launcher process
- postgres: archiver process
- postgres: stats collector process
Have you looked into the documentation? In particular the parts about server administration and the internals.
There additionally are some resources in the wiki, and not a year passes by without one of the core developers going through one or more of the points you're wondering about at a PG Conference.
A quick internet search turned up these documents, I find the first one very interesting: