debug

This tag is associated with 2 posts

Happiness Hint: Alarm on Checkpoint Time

Posted by Jeremy ⋅ June 24, 2026 ⋅ 1 Comment

Before starting, I want to put a few things at the top: Checkpoint is the heart of your database. It’s buried deep inside. It’s not something everyone talks about, like well-tuned autovacuum or fast queries. But if checkpointer stops beating, then you’re dead. In addition to its well-understood job of getting dirty pages written from … Continue reading →

Copy-and-Paste A New Postgres Dev Env In 5 Min

Posted by Jeremy ⋅ January 8, 2024 ⋅ 1 Comment

You can cut-and-paste the following commands to quickly get a new & clean dev environment for working with PostgreSQL source code. This includes Michael Paquier’s powerful script kit for managing the PostgreSQL development environment. Setting up from scratch takes me about 5 minutes, plus 3 minutes to configure, compile and install PostgreSQL for testing. Running the … Continue reading →