Re: performance impact on read replicas during heavy vacuums on primary - Mailing list pgsql-performance

From Greg Sabino Mullane
Subject Re: performance impact on read replicas during heavy vacuums on primary
Date
Msg-id CAKAnmmKSnCSqiJuGT83z33jajq4w0QvKAMzKeMjUTxxoiP_vag@mail.gmail.com
Whole thread Raw
In response to performance impact on read replicas during heavy vacuums on primary  (Dirk Krautschick <dee-kay@gmx.de>)
List pgsql-performance
Is this a theoretical question, or have you seen performance issues? Yes, it is certainly possible for vacuum to affect the replica performance. More vacuum activity means more WAL means more WAL replay on the replica, using up CPU and I/O. In most real-world cases, this will not be a problem, as the replica should be able to keep up quite well even for near-constant vacuum activity. You would need a very high WAL volume and a very underprovisioned replica before seeing any ill effects. There are plenty of other performance bottlenecks that will likely hit you before this one.


Cheers,
Greg
 

pgsql-performance by date:

Previous
From: Dirk Krautschick
Date:
Subject: performance impact on read replicas during heavy vacuums on primary
Next
From: Riaan Stander
Date:
Subject: Postgres IO sweet spot