Bin Wang - PostgreSQL Uncovered Internals, Trace Analysis, and Performance (2026)

File Name

Size

Lesson 1. Why PostgreSQL Is More Than Just Data Storage.html

40 kB

Lesson 2. Inside PostgreSQL Unlocking Secrets with Trace Analysis.html

46 kB

Lesson 3. How a SQL Query Is Executed in PostgreSQL.html

122 kB

Lesson 4. PostgreSQL Architecture Inside the Database Engine.html

79 kB

Lesson 5. PostgreSQL Indexes Deep Dive for Developers.html

105 kB

Lesson 6. Why PostgreSQL Uses Heap Storage.html

46 kB

Lesson 7. How PostgreSQL Finds Rows in a B+ Tree_A Step-by-Step Example.html

143 kB

Lesson 8. B+ Tree Depth in PostgreSQL and Its Performance Impact.html

158 kB

Lesson 9. Index-Only Scans in PostgreSQL When Tables Are Skipped.html

97 kB

Lesson 10. Shared Buffers Explained What PostgreSQL Caches Internally.html

74 kB

Lesson 11. Understanding WAL in PostgreSQL The Write-Ahead Log.html

106 kB

Lesson 12. Inside PostgreSQL Writes From Shared Buffers to Disk.html

124 kB

Lesson 13. Why Doesn’t PostgreSQL Use Undo Logs for MVCC.html

102 kB

Lesson 14. MVCC Internals_How PostgreSQL Keeps Old Versions Alive.html

44 kB

Lesson 15. Autovacuum in PostgreSQL How It Works and When It Fails.html

106 kB

Lesson 16. PostgreSQL VACUUM Understanding Performance, Benefits, and Costs.html

110 kB

Lesson 17. System Catalogs The Metadata Control Center of a Database.html

76 kB

Lesson 18. Inside PostgreSQL How Transactions Really Work.html

128 kB

Lesson 19. PostgreSQL’s Hidden Strength Transactional DDL.html

73 kB

Lesson 20. How PostgreSQL Ensures Atomicity Using MVCC, CLOG, and WAL.html

88 kB

Lesson 21. Data Consistency in PostgreSQL_Constraints and Guarantees.html

113 kB

Lesson 22. Isolation Levels in PostgreSQL_A Practical Introduction.html

227 kB

Lesson 23. Same Isolation Level, Different Behavior PostgreSQL vs MySQL.html

74 kB

Lesson 24. Durability in PostgreSQL_How Crashes Don’t Lose Data.html

100 kB

Lesson 25. Why ROLLBACK Is So Fast in PostgreSQL.html

73 kB

Lesson 26. Checkpoints in PostgreSQL_What They Are and Why They Matter.html

72 kB

Lesson 27. Transaction ID Wraparound Why It Happens and How to Handle It.html

77 kB

Lesson 28. Locks in PostgreSQL_An Easy Guide to Types and Use Cases.html

168 kB

Lesson 29. Do Read-Only Queries Really Need VACUUM in PostgreSQL.html

75 kB

Lesson 30. Inside PostgreSQL’s Planner_From Query to Logical Plan.html

108 kB

Lesson 31. Inside PostgreSQL’s Cost Model How the Planner Thinks.html

173 kB

Lesson 32. How JOINs Work Internally in PostgreSQL.html

184 kB

Lesson 33. Join Tree Structures in Query Optimization.html

176 kB

Lesson 34. Join Enumeration Strategies Dynamic Programming vs Genetic Search.html

203 kB

Lesson 35. How PostgreSQL Reduces the Join Search Space.html

52 kB

Lesson 36. Understanding Join Graph Topology and Its Impact on Query Optimization.html

114 kB

Lesson 37. Why PostgreSQL Handles This JOIN 10× Faster Than MySQL.html

78 kB

Lesson 38. How PostgreSQL Aggregates Work Internally.html

177 kB

Lesson 39. PostgreSQL Parallel Query Execution The Key to Faster Analytics.html

262 kB

Lesson 40. WITH Queries Demystified How PostgreSQL Plans CTEs.html

88 kB

Lesson 41. How Databases Execute Window Functions A Deep Dive.html

108 kB

Lesson 42. Why PostgreSQL Query Optimization Is So Challenging.html

131 kB

Lesson 43. Planner Challenges in Distributed PostgreSQL.html

92 kB

Lesson 44. What PostgreSQL Extensions Are and How They Work.html

85 kB

Lesson 45. Representative PostgreSQL Extensions and Their Capabilities.html

119 kB

Lesson 46. Understanding Hstore’s Extension Mechanism in PostgreSQL.html

86 kB

Lesson 47. How pg_trgm Speeds Up Fuzzy Text Search.html

122 kB

Lesson 48. Inside PostgreSQL Extensions_How FDW Works Under the Hood.html

146 kB

Lesson 49. Inside PostgreSQL Extensions_How Citus Works Under the Hood.html

104 kB

Lesson 50. How Citus Teaches the Planner to Think Globally.html

90 kB

Lesson 51. How Citus Handles Joins Internally.html

77 kB

Lesson 52. Citus Transactions Uncovered How It Really Works.html

107 kB

Lesson 53. How Extensions Shape PostgreSQL Planning and Execution.html

96 kB

Lesson 54. PostgreSQL Extensions_How They Affect Performance and Stability.html

156 kB

Lesson 55. Why Hotspot Updates Hurt PostgreSQL Performance.html

121 kB

Lesson 56. Why Long Transactions May Kill Your PostgreSQL Performance.html

87 kB

Lesson 57. Why Performance Degrades Quickly in Long-Running TPC-C Tests.html

338 kB

Lesson 58. Trace Analysis_Understanding Its Power and Limitations.html

48 kB

Lesson 59. Migrating from MySQL to PostgreSQL Key Differences You Need to Know.html

49 kB

Lesson 60. Becoming a PostgreSQL Expert_Roadmap to Rapid Growth.html

52 kB

Trace Tool/mysql-8.0.42-el7-x86_64-trace-v2.tar.gz

166 MB

Trace Tool/postgresql-17.2-el7-x86_64-trace-v5.tar.gz

25 MB

Trace Tool/postgresql-17.2-el7-x86_64-trace-v7.tar.gz

30 MB

Trace Tool/ReadMe.html

5.3 kB

traces/postgres_lesson_01_select_for_update.log

166 kB

traces/postgres_lesson_01_simple_insert.log

64 kB

traces/postgres_lesson_03.log

65 kB

traces/postgres_lesson_03_mysql_select_for_share.log

47 kB

traces/postgres_lesson_03_select_for_share.log

165 kB

traces/postgres_lesson_04.log

107 kB

traces/postgres_lesson_05_fun_index.log

82 kB

traces/postgres_lesson_05_hot_update.log

237 kB

traces/postgres_lesson_05_partial.log

246 kB

traces/postgres_lesson_07.log

1.1 MB

traces/postgres_lesson_08.log

1.2 MB

traces/postgres_lesson_08_bloat.log

68 kB

traces/postgres_lesson_08_normal.log

358 kB

traces/postgres_lesson_09_index_only_scan.log

72 kB

traces/postgres_lesson_09_index_only_scan_invalid.log

74 kB

traces/postgres_lesson_10_select_point_lookup.log

190 kB

traces/postgres_lesson_11_flusher_bg.log

12 kB

traces/postgres_lesson_11_flusher_wal.log

58 kB

traces/postgres_lesson_11_sess_update.log

134 kB

traces/postgres_lesson_11_sess_update_not_committed.log

252 kB

traces/postgres_lesson_12_multi_update_rows.log

951 kB

traces/postgres_lesson_12_update_basic.log

158 kB

traces/postgres_lesson_13_mysql_mvcc.log

86 kB

traces/postgres_lesson_13_postgres_mvcc.log

159 kB

traces/postgres_lesson_14_mvcc_visit.log

60 kB

traces/postgres_lesson_15_long_transactions.log

627 kB

traces/postgres_lesson_15_vacuum_fail.log

18 MB

traces/postgres_lesson_15_vacuum_success.log

24 MB

traces/postgres_lesson_15_vacuum_with_long_transactions.log

437 kB

traces/postgres_lesson_16_select_behavior_after_vacuum.log

141 kB

traces/postgres_lesson_16_select_behavior_before_vacuum.log

282 kB

traces/postgres_lesson_17_catalog.log

71 kB

traces/postgres_lesson_17_first_visit.log

1.2 MB

traces/postgres_lesson_18_trans.log

748 kB

traces/postgres_lesson_18_trans_failure.log

189 kB

traces/postgres_lesson_19_ddl_trans_commit.log

360 kB

traces/postgres_lesson_19_ddl_trans_rollback.log

343 kB

traces/postgres_lesson_20.log

567 kB

traces/postgres_lesson_21_check_constraint.log

74 kB

traces/postgres_lesson_21_foreign_key_constraint.log

654 kB

traces/postgres_lesson_21_primary_key_constraint.log

122 kB

traces/postgres_lesson_22_rc_session_a.log

1.0 MB

traces/postgres_lesson_22_rc_session_b.log

1000 kB

traces/postgres_lesson_22_rr_comparison_sess_1.log

157 kB

traces/postgres_lesson_22_rr_comparison_sess_2.log

67 kB

traces/postgres_lesson_22_rr_session_a.log

208 kB

traces/postgres_lesson_22_rr_session_b.log

223 kB

traces/postgres_lesson_22_serializable_sesson_a.log

322 kB

traces/postgres_lesson_22_serializable_sesson_b.log

317 kB

traces/postgres_lesson_23_sesson_one.log

323 kB

traces/postgres_lesson_23_sesson_two.log

423 kB

traces/postgres_lesson_24_before_killed.log

763 kB

traces/postgres_lesson_24_checkpoint.log

16 kB

traces/postgres_lesson_24_recovery.log

28 kB

traces/postgres_lesson_25_all_recovery.log

304 kB

traces/postgres_lesson_26_checkpoint.log

12 kB

traces/postgres_lesson_26_do_checkpoint.log

139 kB

traces/postgres_lesson_27_freeze.log

384 kB

traces/postgres_lesson_28_advisory_sess_one.log

163 kB

traces/postgres_lesson_28_advisory_sess_two.log

205 kB

traces/postgres_lesson_28_deadlock_sess_one.log

495 kB

traces/postgres_lesson_28_deadlock_sess_two.log

1.1 MB

traces/postgres_lesson_29_read_only_add_trx_id.log

338 kB

traces/postgres_lesson_29_select_for_share.log

186 kB

traces/postgres_lesson_30_count.log

129 kB

traces/postgres_lesson_30_mysql_count.log

44 kB

traces/postgres_lesson_31_access_method_cost.log

163 kB

traces/postgres_lesson_31_join_method_cost.log

646 kB

traces/postgres_lesson_31_mergejoin_cost.log

545 kB

traces/postgres_lesson_31_mergejoin_plan_error.log

563 kB

traces/postgres_lesson_32_hash_join.log

807 kB

traces/postgres_lesson_32_merge_join.log

1.9 MB

traces/postgres_lesson_32_nested_loop.log

1.8 MB

traces/postgres_lesson_33_join_tree.log

4.0 MB

traces/postgres_lesson_33_join_tree_without_bushy_plans.log

4.0 MB

traces/postgres_lesson_33_mysql_join_tree.log

366 kB

traces/postgres_lesson_34_geqo_sample_tour.log

3.6 MB

traces/postgres_lesson_34_join_dp.log

2.9 MB

traces/postgres_lesson_34_join_geqo.log

59 MB

traces/postgres_lesson_34_join_geqo_optimized.log

3.3 MB

traces/postgres_lesson_35_join_tree.log

3.4 MB

traces/postgres_lesson_36_join_geqo_analyze.log

83 MB

traces/postgres_lesson_38_aggregate_why_hash_sort_not_chosen.log

777 kB

traces/postgres_lesson_38_count.log

6.2 MB

traces/postgres_lesson_38_count_distinct.log

8.2 MB

traces/postgres_lesson_38_hash_aggr.log

11 MB

traces/postgres_lesson_38_sort_aggr.log

12 MB

traces/postgres_lesson_39_parallel_plan.log

167 kB

traces/postgres_lesson_39_parallel_plan_master.log

277 kB

traces/postgres_lesson_39_parallel_plan_worker1.log

2.0 MB

traces/postgres_lesson_39_parallel_plan_worker2.log

2.0 MB

traces/postgres_lesson_40_cte_inline.log

140 kB

traces/postgres_lesson_40_cte_materialized.log

128 kB

traces/postgres_lesson_40_cte_recur.log

810 kB

traces/postgres_lesson_41_window_func.log

225 kB

traces/postgres_lesson_43_extension_citus_select.log

370 kB

traces/postgres_lesson_44_create_extension_simplified.log

2.1 MB

traces/postgres_lesson_45_auto_explain.log

147 kB

traces/postgres_lesson_45_pg_statements.log

141 kB

traces/postgres_lesson_46_hstore.log

596 kB

traces/postgres_lesson_47_trgm_like.log

305 kB

traces/postgres_lesson_48_fdw.log

117 kB

traces/postgres_lesson_48_fdw_join_plan.log

339 kB

traces/postgres_lesson_49_citus.log

433 kB

traces/postgres_lesson_50_citus_plan.log

10 MB

traces/postgres_lesson_51_citus_join_execute.log

10 MB

traces/postgres_lesson_52_citus_dist_trans.log

347 kB

traces/postgres_lesson_54_fgw_under_multi_extentions.log

102 kB

traces/postgres_lesson_54_multi_extensions.log

90 kB

traces/postgres_lesson_55_hot_select.log

776 kB

traces/postgres_lesson_55_hot_update.log

319 kB

traces/postgres_lesson_56_hot_update.log

19 MB

traces/postgres_lesson_56_long_trans_select.log

15 MB

traces/postgres_lesson_56_select.log

18 MB

traces/postgres_lesson_57_vacuum.log

4.7 MB