pgMustard

Moving the pgMustard blog

We will be posting new entries on our own site and not Medium.

Postgres Execution Plans — Field Glossary

An in-depth glossary of Postgres query plan fields — how to…

Multi-column indexes

At pgMustard, we’ve been looking into multi-column indexes recently: particularly…

Postgres indexes for absolute beginners

Indexes are really important for Postgres performance, but they’re often misunderstood and…

Index-only scans in Postgres

Postgres Index-only scans — how, when, and why

Going full-time

A few months ago Dave went full-time on pgMustard… and now I’ve followed suit!

Row count estimates in Postgres

Understanding row count estimates in Postgres and how to fix them

Designing our alpha

While we’ve been building the back end of pgMustard, we’ve also been playing around with what an early version could look…

Reading Postgres Query Plans for Beginners

An introduction to reading query plans for PostgreSQL…