vacuum

This tag is associated with 2 posts

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

Posted by Jeremy ⋅ October 27, 2025 ⋅ 1 Comment

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 →