Monday, February 22, 2016

Postgres Intro



     Postgres follows Process based architecture.

A PostgreSQL session consists of server process which manages the database files, accepts the connections to the database from the client application, and performs database actions on behalf of the clients. 

In other words, the server itself is a process which is running on a database server machine and, each client which connects with the server is a separate process. 

The server is also known as a Postmaster Process which also acts as a supervisor process for all the processes running on the server.

Whenever you start a server and start your database instance it will start Postmaster and several utility processes and memory.

Whenever a user connects with a server, it is a separate process so this separate process will take care of all the user requests. This separate process is started by the Postmaster whenever a user requests for a connection.

No comments:

Post a Comment