Brief architectural overview of several RDBMS - PostgreSQL

  • Print
Details
Published on Saturday, 04 January 2014 17:53
Page 5 of 6

 

PostgreSQL

postgresql architecture

 

   A PostgreSQL session consists of several main processes:

  • A postmaster process serves as a supervisory process that spawns other processes and listens for user connections;
  • A user process such as psql is used for interactive SQL queries;
  • One or more server processes named postgres are spawned by postmaster to handle users' requests for data;
  • The server processes communicate with each other through semaphores and shared memory.
Share