PG-DBA training 10: PostgreSQL transaction processing and concurrency control

1、 Brother Feng PG-DBA training 10: PostgreSQL transaction processing and concurrency control

Course objectives:

This course is a series of courses based on PostgreSQL database released by Brother Feng. This course belongs to PostgreSQL transaction processing and concurrency control at the basic and core technology stage of PostgreSQL. After learning this course, you can master PostgreSQL transaction isolation level, PostgreSQL MVCC mechanism, PostgreSQL transaction commit log, PostgreSQL transaction rollback and transaction freeze, PostgreSQL WAL log parsing, PostgreSQL WAL working principle, PostgreSQL CheckPoint checkpoint, PostgreSQL WAL file structure, PostgreSQL WAL log file switching, PostgreSQL WAL log archive management, PostgreSQL lock management, The classification and concept of PostgreSQL locks, PostgreSQL deadlock query analysis and resolution and other technical contents are suitable for operation and maintenance personnel/database/developers, and can be used in business production environments.

Welcome to:

51CTO school style brother Oracle/MySQL/PG database learning dedicated QQ group: 454129134, 925203979

II Brother Feng PG-DBA training 10: PostgreSQL transaction processing and concurrency control

1. PostgreSQL transaction isolation level

2. PostgreSQL MVCC mechanism

3. PostgreSQL transaction commit log

4. PostgreSQL transaction rollback and transaction freeze

5. PostgreSQL WAL log resolution

(*) How PostgreSQL WAL Works

(*) PostgreSQL CheckPoint

(*) PostgreSQL WAL file structure

(*) PostgreSQL WAL log file switching

(*) PostgreSQL WAL log archive management

6. PostgreSQL lock management

(*) Classification and concept of PostgreSQL locks

(*) PostgreSQL Deadlock Query Analysis and Resolution

3、 Fengge Oracle/MySQL/NoSQL training class series courses (system, case, actual combat)

one ） Oracle Cloud database engineer training course _ Study Guide _ Career planning _ treatment

Free audition: https://edu.51cto.com/course/7015.html

Registration consultation: https://edu.51cto.com/mic-position/131.html

two ） MySQL Database Engineer Training Course _ Study Guide _ Career planning _ treatment

Free audition: https://edu.51cto.com/course/7015.html

Registration consultation: https://edu.51cto.com/mic-position/303.html

three ）Dual database (Oracle+MySQL) Sharing of series of training courses one point five (regularly updated)

http://www.fgedu.net.cn/oracle.html

4、 Big Data Operation and Maintenance Architects Practical Training Topic 2.0

--------------------------------------------------------------------------------

Address: https://edu.51cto.com/topic/4539.html

Familiar with Hadoop big data ecological technology framework, including Cloudera CDH HDFS、Yarn、Hbase、Hive、

Zookeeper, Kafka, Spark, Flink, Flume, Sqoop, ETL/Kettle, ELK, Azkaban and other groups

Component installation configuration and daily maintenance management. Including the construction and maintenance of OLAP database platforms such as Elastic Search, ClickHouse, GreenPlum, TiDB, etc.