benchmark

This tag is associated with 3 posts

Zero autovacuum_vacuum_cost_delay, Write Storms, and You

Posted by Jeremy ⋅ April 12, 2026 ⋅ 4 Comments

A few days ago, Shaun Thomas published an article over on the pgEdge blog called [Checkpoints, Write Storms, and You]. I left a few comments [on LinkedIn]. This article is a great technical read about an important and overlooked topic – and I always love seeing real test results to illustrate the details. I don’t … Continue reading →

Good Benchmark Engineers and Postgres Benchmark Week

Posted by Jeremy ⋅ August 18, 2024

There are four major components to being a good benchmark engineer: Methodology: A good benchmark engineer defines the goals and non-goals of the exercise, makes strong choices on variables in the experiment, configures the SUT in a valid manner, and makes smart decisions about when and how to iterate the test. Investigation: A good benchmark … Continue reading →

UUID Benchmark War

Posted by Jeremy ⋅ February 3, 2024 ⋅ 5 Comments

This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war. I have decided to orchestrate a benchmark war between four different methods of storing a primary key: use a text field to store … Continue reading →