Home

A practical and clear overview of Postgres lock types, their behaviors, and real-world implications.

This lecture explores write amplification across application, database, and storage levels, highlighting its impact on performance and hardware longevity.

Exploring NULLs in databases, their storage in PostgreSQL using null bitmaps, and their impact on query performance, with practical tips for optimization.

A summary of a lecture discussing Uber's 2016 migration from Postgres to MySQL, covering technical challenges, community backlash, and lessons on database choices.

A comparison of indexing mechanisms in PostgreSQL and MySQL, highlighting their differences in performance for reads and writes.

A deep dive into hash tables, their use in database joins, limitations, and how consistent hashing solves scaling issues in distributed systems.

A lecture note on distributed transactions, covering their purpose, challenges, and solutions like atomic clocks, compensating transactions, event-driven architectures, and monoliths.

Exploring whether QUIC, a UDP-based protocol, could enhance database performance by replacing TCP-based connection pooling.