Reading PostgreSQLAugust 28, 2026·13 min readThe Anatomy of Query Structure 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.PostgreSQLTechnicalPGSourceCode352
Reading PostgreSQLAugust 8, 2026·10 min readVacuum - PostgreSQL way of clearing it's DebtVacuum in PostgreSQL helps reclaiming the space occupied by dead tuples. Here in this blog, we discusses about how Vacuum do in PostgreSQL internally.PostgreSQLTechnicalPGSourceCode962
Monthly Books SummaryJuly 31, 2026·2 min readWhat I read in July 2026Summary about the books I read in July 2026BooksPersonal122
PostgreSQL InternalsJuly 17, 2026·12 min readPostgreSQL Internals - Module 9: ReplicationFinal blog post of the PostgreSQL Internals series explaining about Replication and it's type i.e., Physical and Logical Replication. PostgreSQLTechnicalPGInternals231🔥1
Monthly Books SummaryJune 28, 2026·2 min readWhat I read in June 2026Summary about the books I read in the month ofJune 2026BooksPersonal193
Reading PostgreSQLJune 22, 2026·7 min readPostgreSQL Table Statistics: When, Where, and How They're CalculatedUnderstand and Learn about the PostgreSQL Table's Statistics and in-depth code walkthroughPostgreSQLTechnicalPGSourceCode793
Reading PostgreSQLJune 13, 2026·6 min readTableAmRoutine - your way of integrating a custom storage engine into PostgreSQLLearn how TableAmRoutine works under the hood and use it to plug your custom storage engine into PostgreSQL without touching the core.PostgreSQLTechnicalPGSourceCode913🔥2🧠1👏1
June 5, 2026·9 min readBuilding a Local PostgreSQL Internals Assistant - Zero API CostsLocal PostgreSQL internals assistant - semantic search over PG source via pgvector + Ollama, exposed as MCP tools in Zed and VSCode. Free, offline, zero API costs.TechnicalArtificial IntelligenceLLM997🔥2👏2