Re: Bi-modal streaming replication throughput

2018-08-17 Thread Andres Freund
On 2018-08-17 15:21:19 +0200, Alexis Lê-Quôc wrote: > On Tue, Aug 14, 2018 at 7:50 PM Andres Freund wrote: > > > Hi, > > > > On 2018-08-14 10:46:45 -0700, Andres Freund wrote: > > > On 2018-08-14 15:18:55 +0200, Alexis Lê-Quôc wrote: > > > > + 30.25%26.78% postgres postgres [.]

Re: Bi-modal streaming replication throughput

2018-08-14 Thread Andres Freund
Hi, On 2018-08-14 15:18:55 +0200, Alexis Lê-Quôc wrote: > We run > a cluster of > large, SSD-backed, i3.16xl (64 cores visible to Linux, ~500GB of RAM, with > 8GB of shared_buffers, fast NVMe drives) nodes > , each > running PG 9.3 > on linux > in a vanilla streaming asynchronous replication

Re: Bi-modal streaming replication throughput

2018-08-14 Thread Jeff Janes
On Tue, Aug 14, 2018 at 9:18 AM, Alexis Lê-Quôc wrote: > each running PG 9.3 on linux That is the oldest version which is still supported. There have been a lot of improvements since then, including to performance. You should see if an upgrade solves the problem. If not, at least you will

Bi-modal streaming replication throughput

2018-08-14 Thread Alexis Lê-Quôc
Hi, I have been puzzled by very different replication performance (meaning 50-100x slower) between identical replicas (both in “hardware” and configuration) once the amount of data to replicate increases. I’ve gone down a number of dead ends and am missing something ( likely obvious ) that I hope