# pg-mastery

A personal, mostly Chinese-language PostgreSQL knowledge base by a PostgreSQL DBA, collecting articles and write-ups on internals, DBA practice, performance tuning, and production troubleshooting.

pg-mastery is a personal PostgreSQL knowledge base maintained by a PostgreSQL DBA, gathering articles on database internals, DBA practices, performance tuning, troubleshooting, ecosystem developments, and real production incidents. The material is organized under topics such as database principles, the query optimizer, parallel query, database ecosystem comparisons, execution plans, statistics, page pruning, storage space accounting, and specific production cases like duplicate primary keys, multiple postmasters, and unusual dead-tuple counts.

Most of the listed articles are the author's own write-ups, in Chinese, and the repository also links to related English-language articles on Postgres query execution and optimization. The author is also credited as the founder of a PostgreSQL how-to project in Chinese and as a translator of a PostgreSQL internals book into Chinese.

Website: https://github.com/xiongcccc/pg-mastery