October 11th, 2012, 12:13 PM
Join Date: Oct 2003
I don't know what "hidden" should mean.
After a startup you have the following processes running (all named postgres)
- postmaster (controls the others)
- logger process
- checkpoint writer
- writer process
- stats collector
- wal writer
- autovacuum launcher
The autovacuum launcher will actually start another postgres process in regular intervals (the one which will do the actual vacuum work)
If you are on windows you'll see an additional process pg_ctl that started all of them.
And then you'll have one process for each connection that is made to the database.
If you are on linux you will see all these names in the output of the ps command.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions: