20 docs tagged with "performance"

EXPLAIN ANALYZE or EXPLAIN (ANALYZE, BUFFERS)?

UPDATE 2025: Starting with Postgres 18, the `BUFFERS` option becomes default in `EXPLAIN ANALYZE`, which is great news.

Benchmarking is a huge topic. Here, we cover minimal steps that are required for a Postgres benchmark to be informative,

Detect, measure, and eliminate table and index bloat to maintain database health

Identify and handle long-running transactions that can impact OLTP system performance

"Slow" is a relative concept. In some cases, we might be happy with query latency 1 minute (or no?), while in other

// I post a new PostgreSQL "howto" article every day. Join me in this journey – subscribe, provide feedback, share!

Learn how to how to run analyze (to collect statistics)

After a series of rather hefty posts, let's take a breather with some lighter material.

Today we'll discuss how to understand what exactly a Postgres backend is doing inside CPU on a Linux machine (in-CPU analysis).

Understand subtransactions, savepoints, and their impact on database performance