How OpenAI Scales Postgres to Power 800 Million ChatGPT Users — Did you know Postgres sits at the heart of ChatGPT? Operating at an incredibly high scale, OpenAI shares the story of how they have Postgres supporting millions of queries per second using read replicas and only a single primary (no sharding!) This article builds upon a popular talk Bohan gave at PGConf․dev last year.

Bohan Zhang (OpenAI)

The Postgres Extension for Time-Series at Scale — TimescaleDB extends Postgres with hypertables for automatic partitioning, 95% compression, and continuous aggregates that refresh in real-time. No new database to manage, no new query language to learn. It's just Postgres, faster. Start building for free.

Tiger Data sponsor

🔎 Finding ‘Abbey Road’ When Users Type ‘beatles abbey rd’ — An introduction to both fuzzy search with pg_trgm and semantic search with pgvector using a dataset of over 100,000 songs as an example.

Daniel Guzman Burgos

An Introduction to Buffers in Postgres — Buffers are a fundamental part of what makes Postgres tick internally, but they’re often overlooked in tutorials, beyond tweaking a few config settings for performance. Radim explains what they’re actually doing.

Radim Marek

Why Your HA Architecture Is a Lie (And That's Okay) — “Stop chasing perfection. Model your architecture for reality”, says Lætitia in a brief exploration of some common misconceptions around high availability.

Lætitia Avrot

WITHOUT OVERLAPS Constraints, Now in Postgres 18 — Temporal features arrived in SQL:2011 and, in SQL:2023, were standardized as optional features. Long available in Db2 and MariaDB, WITHOUT OVERLAPS landed in Postgres 18, allowing inserts with overlapping time ranges to be rejected.

Neon

An Introduction to Postgres Indexes — A foundational overview for developers familiar with indexes at a high level but who want to get a better feel for what’s happening under the hood.

Dalto Curvelano

🤖 Postgres Best Practices for Coding Agents — A series of Postgres best practices you can easily install to give coding agents like Claude Code or Codex an extra edge, taking into account Postgres specifics like RLS, connection management, and Postgres-specific SQL features. And even if you don’t use AI, you can read all the guides here in Markdown form.

Pedro Rodrigues (Supabase)

RegreSQL 1.5: Regression Testing for SQL Queries — The idea is simple: take your queries, run them, capture expected results, then on future runs compare when their cost, I/O or other characteristics change. “When a query’s result changes unexpectedly, you’ll know immediately.” GitHub repo.

boringSQL

✉️ pg_utl_smtp 1.0: Oracle UTL_SMTP Compatible Extension for Postgres — UTL_SMTP is an Oracle Database package for sending email over SMTP direct from database procedures. This extension brings the same API to Postgres.

HexaCluster