Stories by lfittl

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

Constraint Programming in Action: Optimizing Postgres Index Selection

A practical introduction to constraint programming using CP-SAT and Python

Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io

Soft deletion probably isn't worth it

PostgreSQL 15 Beta 1 Released

SQL: One of the Most Valuable Skills

How Postgres Chooses Which Index to Use for a Query

A detailed guide to colors in data vis style guides

What Makes Postgres Great

Understanding Postgres GIN Indexes: The Good and the Bad

Show HN: pganalyze Index Advisor – A better way to index your Postgres database

An early look at Postgres 14: Performance and Monitoring Improvements

Efficient Postgres Full Text Search in Django

Building a recommendation engine inside Postgres with Python and Pandas

Using Postgres and pgRouting to explore the smooth waves of yacht rock (2020)

Things we learned running Postgres 13

Control Runaway Postgres Queries with Statement Timeout

Read/Write Splitting with Azure Postgres

The Engineering Manager/Product Manager Marriage