D#2: PostgreSQL Background Process Architecture || Installation on Windows 11|| #postgresqldba

PostgreSQL Background processes PostgreSQL has numerous background processes each has its own role to play for the successful functioning of the database. List of PostgreSQL background processes: Background writer Checkpointer Autovacuum launcher WAL writer Statistics collector Logging collector Archiver Autovacuum (worker processes and auto vacuum launcher): The task of automatically recovering space and improving database performance falls to Autovacuum. The process that launches the autovacuum oversees starting those operations regularly. On individual tables, autovacuum worker processes handle the actual vacuuming and upkeep. WAL Writer (walwriter): The Write-Ahead Log (WAL) data is written to disk by the WAL Writer process. For replication and crash recovery, WAL is employed. Checkpointer (checkpointer): The task of writing dirty data (modified data) from shared buffers to disk is carried out by the checkpointer process. It aids in minimizing the amount of time required for database recovery following a crash. Background Writer (bgwriter): When the system is idle, the Background Writer processes overseas writing data from shared buffers to disk. Performance is enhanced and I/O load is decreased. WalReceiver (walreceiver): The streaming replication capability includes the WalReceiver procedure. In a streaming replication system, it receives and applies Write-Ahead Log (WAL) records from the primary server. WalSender (walsender): The Archiver process must archive the Write-Ahead Log (WAL) data to a specific archive location. Point-in-time recovery can benefit from archiving. Archiver (archiver): The Write-Ahead Log (WAL) data must be archived in a specific archive location by the Archiver process. Point-in-time recovery can benefit from archiving. Stats Collector (stats collector): Statistics regarding database activity, including the number of queries, index usage, and connections, are gathered by the Stats Collector process. Tools for monitoring and query optimization use this data.