Walking through PostgreSQL concepts directly from the source code
Learn how TableAmRoutine works under the hood and use it to plug your custom storage engine into PostgreSQL without touching the core.
Understand and Learn about the PostgreSQL Table's Statistics and in-depth code walkthrough
Vacuum in PostgreSQL helps reclaiming the space occupied by dead tuples. Here in this blog, we discusses about how Vacuum do in PostgreSQL internally.
How PostgreSQL represents SQL internally: a field-by-field tour of the Query struct, from range tables and target lists to joins, grouping, and permissions.