Uncategorized

In the last post we discussed about checkpoint process, in this tutorial we will discuss about PostgreSQL: stats collector PostgreSQL: stats collector The stats collector process collects statistics about the database. It’s an optional process with the default value as on. The process keeps track of access to tables and indexes in both disk-block and … Read more

PostgreSQL Background writer In the last post we discussed about checkpoint process, in this tutorial we will discuss about “postgres: Background writer” Background writer writes dirty buffers into the datafiles. PostgreSQL: Background writer : postgres: Background writer is started by the postmaster process during the start of instance. According to the documentation, There is a … Read more