Full Text Search in Milliseconds with Rails and PostgreSQL (2020)

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

Postgres 17: Streaming I/O for sequential scans and ANALYZE

Postgres Incremental Backup

An automatic indexing system for Postgres

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

How Postgres chooses which index to use for a query

We deconstructed the Postgres planner to find indexing opportunities

An early look at Postgres 14: Performance and Monitoring Improvements

An early look at Postgres 14 performance and monitoring improvements

Introducing pg_query 2.0: The easiest way to parse Postgres queries

Things we learned running Postgres 13

Effectively Using Materialized Views in Ruby on Rails

Similarity in Postgres and Rails Using Trigrams

Efficient GraphQL Queries in Ruby on Rails and Postgres

New in Postgres 11: Monitoring JIT Performance, Auto Prewarm, Stored Procedures

Visualizing & Tuning Postgres Autovacuum