Home

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.

A detailed look at PostgreSQL's process-based architecture, covering the postmaster, backend processes, background workers, and auxiliary processes like WAL and autovacuum.

A lecture explaining how databases store data on HDDs and SSDs, including block organization and the impact of data structures like B-trees and LSM trees.