Simon Willison’s Weblog

PostgreSQL Performance Optimisation

11th September 2003

Via the pgsql-performance mailing list, a great guide to Tuning PostgreSQL for performance, accompanied by a huge table of annotated configuration options.

Posted 11th September 2003 at 11:14 am · Follow me on Mastodon, Bluesky, Twitter or subscribe to my newsletter

More recent articles

Video + notes on upgrading a Datasette plugin for the latest 1.0 alpha, with help from uv and OpenAI Codex CLI - 6th November 2025
Code research projects with async coding agents like Claude Code and Codex - 6th November 2025
A new SQL-powered permissions system in Datasette 1.0a20 - 4th November 2025

This is PostgreSQL Performance Optimisation by Simon Willison, posted on 11th September 2003.

Next: Jump!

Previous: Javascript free rollovers

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe

Previously hosted at http://simon.incutio.com/archive/2003/09/11/pgPerformance