vacuum

This tag is associated with 3 posts

Zero autovacuum_vacuum_cost_delay, Write Storms, and You

Posted by Jeremy ⋅ April 12, 2026 ⋅ 5 Comments

A few days ago, Shaun Thomas published an article over on the pgEdge blog called [Checkpoints, Write Storms, and You]. Sadly a lot of corporate blogs don’t have comment functionality anymore. I left a few comments [on LinkedIn], but overall let me say this article is a great read, and I’m always happy to see … Continue reading →

Explaining IPC:SyncRep – Postgres Sync Replication is Not Actually Sync Replication

Posted by Jeremy ⋅ October 27, 2025 ⋅ 2 Comments

Postgres database-level “synchronous replication” does not actually mean the replication is synchronous. It’s a bit of a lie really. The replication is actually – always – asynchronous. What it actually means is “when the client issues a COMMIT then pause until we know the transaction is replicated.” In fact the primary writer database doesn’t need … Continue reading →

This Week in PostgreSQL – May 31

Posted by Jeremy ⋅ June 4, 2018

Since last October I’ve been periodically writing up summaries of interesting content I see on the internet related to PostgreSQL (generally blog posts). My original motivation was just to learn more about PostgreSQL – but I’ve started sharing them with a few colleagues and received positive feedback. Thought I’d try posting one of these digests … Continue reading →