$ WAL: How Databases Survive a Crash
An application says “saved.” A second later, the database process crashes. After restart, the record is still there. That feels ordinary because databases have made a difficult…
An application says “saved.” A second later, the database process crashes. After restart, the record is still there. That feels ordinary because databases have made a difficult…
A query is slow. You add an index to the column in its WHERE clause. You run it again. Still slow. At this point it's tempting to assume that PostgreSQL is ignoring an obvious…
The Data Structure Powering Every Database You've Ever Used If you've ever run a query with a WHERE clause on a column that has an index, you've already benefited from a B tree.…