About Lessons Blog

Lessons

Every lesson runs against a real PostgreSQL database in your browser.

Get notified when I publish new lessons

First name

Email

Indexes

1.How PostgreSQL executes a SQL statement
2.Understanding PostgreSQL execution plans
3.Using EXPLAIN ANALYZE to measure actual execution
4.Improving query performance with indexes

Pagination

1.Paginating results with LIMIT and OFFSET
2.Understanding the cost of large OFFSETs
3.Introducing keyset pagination
4.Keyset pagination with multiple sort columns
5.Navigating forward and backward with keyset pagination
6.Choosing between offset and keyset pagination

Transactions and Concurrency

1.Why transactions exist
2.Using BEGIN, COMMIT, and ROLLBACK
3.Why transactions alone don't prevent race conditions
4.Understanding MVCC
5.Understanding READ COMMITTED
6.Preventing race conditions
7.Using REPEATABLE READ and SERIALIZABLE
8.Understanding deadlocks
9.Using savepoints