Programmer Think

sql execution statement flow analysis The whole processing flow is in exec_simple_query function. The code structure is as follows: /* * exec_simple_query * * Execute a "simple Query" protocol message. */ static void exec_simple_query(const char *query_string) { ... //Original syntax tree acquisition /* * Do basic parsing of the quer ...

Author: Yanbo Qingyun technology database R & D EngineerAt present, he is engaged in the development of PostgreSQL products and is keen on the study and research of PostgreSQL databaseLast issue We introduced the PG cluster replication management tool repmgr, which can easily build a highly available cluster of PostgreSQL. After the primary ...

What is TCC? TCC is the abbreviation of Try, Confirm and Cancel. It was first proposed by a paper entitled Life beyond Distributed Transactions:an Apostate's Opinion published by Pat Helland in 2007.TCC compositionTCC is divided into three stagesTry phase: try to execute, complete all business checks (consistency), and reserve necessary busines ...

Author: Zhang Lianzhuang, PostgreSQL R & D Engineer He has been engaged in the development of PostgreSQL database kernel for many years and has a very in-depth research on citus. Recovering lost data quickly is an important functional requirement of the database. It is generally recommended to use the tools recommended by the official. For ...

preface The story happened on a dark and windy night. An unusual phone call came and said that the business was in a hurry to go online, but their API package could not be uploaded to the company's maven private library. The leader asked me to support and see how to solve it. After years of unreliable intuition, the disk should be full. So he ...

catalogue environment Document purpose detailed information environment System platform: Linux x86-64 Red Hat Enterprise Linux 7 Version: 4.3.4.7 Document purpose This paper mainly introduces how to mine the database wal log through walminer, including the installation and use of wal. detailed information 1, Introduction to walminer 1. Brief ...

Decentralized open source social platform – misskey I can't bear to see the leaders deploy mammoths. In fact, I also want to have my own district centered social platform... hmmm, but mammoths eat too much memory. Is there a better source program? So I found this high color value and low occupancy program misskey on github ##Program int ...

1. Description The description of each component is shown in the table below: assemblyeditionThe serverInstallation tutorialeffectcanal1.1.5canal1, canal2, canal3canal HA installation + mysql multi node automatic switchingzookeeper3.6.3canal1, canal2, canal3zookeeper fully distributed installationmysql8.0.25canal1, canal2MySQL master mast ...

The temporary tablespace of PostgreSQL, through the parameter temp_tablespaces are configured. PostgreSQL allows users to configure multiple temporary tablespaces. When configuring multiple temporary tablespaces, use commas to separate them. If temp is not configured_ Tablespaces parameter. The temporary tablespace corresponds to the default ...

PostgreSQL is an object relational database management system (ORDBMS) of free software with complete characteristics. It is an object relational database management system based on POSTGRES, version 4.2 developed by the computer department of the University of California. Many of the leading concepts ...