Home

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.

Exploring Shopify's transition from UUID to ULID for idempotency keys to boost database performance in payment systems.

Exploring why SELECT COUNT(*) queries can slow down database performance and practical solutions like index-only scans and table vacuuming.

Exploring the fundamental differences between Postgres and MySQL, focusing on indexing strategies and their impact on performance.

A lecture on how database index creation affects write operations and the benefits of concurrent indexing.

A summary of Hussein Nasr's lecture from The Back End Engineering Show, discussing the role of Write-Ahead Logs (WAL), redo logs, and undo logs in ensuring database durability and crash recovery.

This Q&A session covers key database engineering concepts including indexing in PostgreSQL, durability in Redis, lock management in transactions, and the differences between various indexing strategies.