Writing / 05
Writing
Longer explanations of ideas I have tested, systems I have studied, and lessons I want to remember.
0102030405
PostgreSQL Tuples: What Really Happens to a Row
Notes on how PostgreSQL stores row versions, what ctid, xmin and xmax tell us, and how VACUUM cleans up after them.
PostgreSQL · Databases · MVCCDNS: How a Name Becomes an Address
Notes on DNS: the hierarchy, zones and records, how resolution works, and why caching makes it scale.
Networking · DNSComputer Networking Fundamentals: Part 1
Notes on networking fundamentals, from IP and MAC addresses to namespaces, bridges, routing, iptables and NAT.
Networking · LinuxTable Partitioning in Relational Databases
How PostgreSQL partition pruning avoids scanning irrelevant data and changes a query's execution plan.
PostgreSQL · Databases · PerformanceSQL JOIN: Condition in ON vs. WHERE
How conditions in ON and WHERE behave differently with inner and outer joins.
SQL · Databases