Table of contents
No headings in the article.
PostgreSQL is an Object Relational Database Management System.
It's also called ORDMS.
It's an Open-Source Database Management System.
It uses MYSQL standards.
It follows a client-server architecture.
Client Applications: PostgreSQL can be accessed by various client applications such as command-line tools, graphical user interfaces (GUIs), web applications, and programming languages.
Server: The PostgreSQL server is the core component that manages the database and handles client requests. It consists of several processes and components:
Postmaster: This is the main process that manages the database connections, authentication, and other server-level operations.
Background Writer (BGW): It manages the writing of modified data from memory (shared buffers) to disk (data files) to ensure data durability.
Checkpointer: This process writes dirty pages from shared buffers to disk and updates the checkpoint records.
Autovacuum Launcher: It automatically initiates the vacuuming and analyzing of tables to reclaim disk space and update query statistics.
Shared Memory: PostgreSQL uses shared memory to facilitate communication and data sharing among various server processes.