官术网_书友最值得收藏!

  • Learning PostgreSQL 11
  • Salahaldin Juba Andrey Volkov
  • 382字
  • 2021-07-02 13:11:43

PostgreSQL architecture

PostgreSQL uses the client/server model, where the client and server programs can be on different hosts. The communication between the client and server is normally done via TCP/IP protocols or via Linux sockets. PostgreSQL can handle multiple connections from a client. A common PostgreSQL program consists of the following operating system processes:

  • Client process or program (frontend): The database frontend application performs a database action. The frontend can be a web server that wants to display a web page or a command-line tool to do maintenance tasks. PostgreSQL provides frontend tools such as psql, createdb, dropdb, and createuser.
  • Server process (backend): The server process manages database files, accepts connections from client applications, and performs actions on behalf of the client. The server process name is postgres. PostgreSQL's main server process forks a new process for each new connection; thus, client and server processes communicate with each other without the intervention of the main server process (postgres), and they have a certain lifetime, which is determined by accepting and terminating a client connection.

The aforementioned abstract conceptual PostgreSQL architecture gives an overview of the PostgreSQL capabilities and its interaction with the client and the operating system. The PostgreSQL server could be divided roughly into four subsystems, as follows:

  • Process manager: The process manager client connections, such as forking and the terminating process. It also handles background services, such as logger, and WAL writer processes. 
  • Query processor: When a client sends a query to PostgreSQL, the query is parsed by the parser, and then the traffic cop subsystem determines the query type. A utility query is passed to the utilities subsystem. SELECT, INSERT, UPDATE, and DELETE queries are rewritten by the rewriter, following which an execution plan is generated by the planner. Finally, the query is executed and the result is returned to the client.
  • Utilities: The utilities subsystem provides a means to maintain the database, such as claiming storage, updating statistics, and exporting and importing data with a certain format or logging.
  • Storage manager: The storage handles the memory cache, disk buffers, and storage allocation.

Almost all PostgreSQL components can be configured, including a logger, planner, statistical analyzer, and storage manager. PostgreSQL configuration is governed by the nature of the application, such as OLAP, OLTP, and HATP.

主站蜘蛛池模板: 博野县| 宾川县| 武鸣县| 上高县| 涞水县| 天门市| 错那县| 莫力| 临武县| 罗平县| 上饶县| 南阳市| 兰州市| 台安县| 五河县| 林口县| 霞浦县| 嘉鱼县| 饶河县| 兴城市| 托克托县| 鸡西市| 鞍山市| 锦屏县| 民勤县| 凯里市| 江都市| 贵南县| 宣城市| 新巴尔虎左旗| 崇阳县| 沁水县| 宝鸡市| 封丘县| 迁安市| 自贡市| 海宁市| 通许县| 孟津县| 静宁县| 甘德县|