Re: Bi-modal streaming replication throughput

From: Andres Freund <andres(at)anarazel(dot)de>
To: Alexis Lê-Quôc <alq(at)datadoghq(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bi-modal streaming replication throughput
Date: 2018-08-17 13:46:34
Message-ID: 20180817134634.o7mfotigxxmy25yn@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 2018-08-17 15:21:19 +0200, Alexis Lê-Quôc wrote:
> On Tue, Aug 14, 2018 at 7:50 PM Andres Freund <andres(at)anarazel(dot)de> 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 [.] mdnblocks
> > >
> > > This I've likely fixed ~two years back:
> > >
> > >
> > http://archives.postgresql.org/message-id/72a98a639574d2e25ed94652848555900c81a799
> >
> > Err, wrong keyboard shortcut *and* wrong commit hash:
> >
> > https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=45e191e3aa62d47a8bc1a33f784286b2051f45cb
> >
> > - Andres
> >
>
> Thanks for the commit in the first place and the reference now; that's a
> very logical explanation. We're now off 9.3.

Glad to help. Did the migration appear to have resolved the worst
performance issues?

Greetings,

Andres Freund

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Fred Habash 2018-08-17 18:07:12 Re: Guideline To Resolve LWLock:SubtransControlLock
Previous Message Alexis Lê-Quôc 2018-08-17 13:21:19 Re: Bi-modal streaming replication throughput