A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING

Another look into PostgreSQL CTE materialization and non-idempotent subqueries

Selective async commits in PostgreSQL – balancing durability and performance

Scaling with PostgreSQL without boiling the ocean

Database mocks are not worth it

Using CTID Based Pagination for Data Cleanups in PostgreSQL

Beyond logical replication: pg_easy_replicate Supports Tracking DDL Changes

Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL

Do you really need foreign keys?

Non blocking and zero downtime ALTER statements in PostgreSQL with pg-osc

Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective