Understanding PostgreSQL Checkpoints: From WAL to Disk
A deep dive into how PostgreSQL checkpoints work, from Write-Ahead Logging to persisting data on disk, with practical monitoring commands.
All Posts
PostgreSQL Fundamentals: Monitoring and Administration Tools (Part 6)
Learn the essential PostgreSQL monitoring tools and system views for understanding database internals, WAL activity, and checkpoint behavior.
PostgreSQL Fundamentals: Write-Ahead Logging Deep Dive (Part 5)
Deep dive into PostgreSQL's Write-Ahead Logging: how it works, what's inside WAL records, and how it enables both durability and crash recovery.
PostgreSQL Fundamentals: Performance Patterns and Trade-offs (Part 4)
Learn the performance trade-offs database systems face: write amplification, I/O batching, and why PostgreSQL makes the design choices it does.
PostgreSQL Fundamentals: Transactions and ACID (Part 3)
Learn what database transactions are, why ACID properties matter, and how PostgreSQL ensures your data stays consistent even when things go wrong.
PostgreSQL Fundamentals: How Databases Store Data (Part 2)
Learn how PostgreSQL organizes data on disk using pages, tables, and indexes. Understand the building blocks of database storage.
PostgreSQL Fundamentals: Memory vs Disk Performance (Part 1)
Understand the fundamental difference between memory and disk performance, and why this matters for database systems like PostgreSQL.
Ruby 3.4 Adds Array#fetch_values for Safe Multi-Index Access
Ruby 3.4 introduces Array#fetch_values to safely retrieve multiple array elements with default value support, bringing consistency with Hash#fetch_values.
Rails pluralize Just Got 4x Faster
Rails optimizes pluralize with regex caching and structural changes, delivering up to 4x performance improvement for uncountable words
DHH's Rails World 2025 Keynote: We're All CRUD Monkeys, and That's OK
DHH admits we're all CRUD monkeys, kills system tests, shows off his Linux distro, and reminds us that deployment used to take 5 seconds with FTP.