Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqf5P-0005q1-QZ for pgsql-performance@arkaria.postgresql.org; Fri, 17 Aug 2018 13:46:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fqf5O-0000S1-33 for pgsql-performance@arkaria.postgresql.org; Fri, 17 Aug 2018 13:46:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqf5M-0000Ru-O3 for pgsql-performance@lists.postgresql.org; Fri, 17 Aug 2018 13:46:41 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqf5J-0006e8-LS for pgsql-performance@postgresql.org; Fri, 17 Aug 2018 13:46:39 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id EDCB921A7B; Fri, 17 Aug 2018 09:46:36 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Fri, 17 Aug 2018 09:46:36 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; bh=Un/prggpN+D1SvT/RXzqlFrIkAHql qrpBXoCdwgiy+E=; b=ysMx0aWQBFoPJfT037h2sBGuNWecMX6ZffNH/NFopIaZi wCmN5cIwP5iCSXq182dDRd/ejWWNOlJ/NYE4oEnyMESScefuD5LukD+NFynq7Kgm EZkn0oTfvJx3OMuGwHUYzRLZiMuxxsOjOLMIz/lScjbqxcg4WyD8p6C19lj83NV9 usr4wBY8y1WstlH1BkV6B1RQwFoABkZk1/YuVInqVSPKQGK2mU45NNM/izGDcvhz rOXA34C+pKEqxvt2BOtnD9k93t1yCZ7gfyUfIskkgOeP9JwwVRHv7Eg8y1ScUkUd +BBNpNmbknC25q8s4bBiIOia47Tq6ROf57UCwsWHQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=Un/prg gpN+D1SvT/RXzqlFrIkAHqlqrpBXoCdwgiy+E=; b=JVbolh7Ks41gxhFA3IS1ba 4b44/EeRU6BPO25hP/PlnaqMQMtjmucob3+L1r+IdI+FH9xhXs7/8ct//XT3cvtX 9YclGFyFylwVLsmLJGf0ZU4LxVsQYbdBrjVLlNxDjvKCs7JFuthevEnLvMqWtJ66 fHhXNJ8meTjCQMuh2zJ8LvjEiq8kiCCCBbTkNd/9kHAUhT/MRPqibIMrFRRW9VFS jx88kLhUBOyAievIcaV49+pgxZMf8f1sWhIo5omBpwv4lW47eV+sSVhVa2b8kXbQ u1taMjLsud3xQVA99pvyX1E8lpTT8HnicM8skjCwDlbWnPDF7gedw8zDNm2VjKjg == X-ME-Proxy: X-ME-Sender: Received: from intern.anarazel.de (p5de63426.dip0.t-ipconnect.de [93.230.52.38]) by mail.messagingengine.com (Postfix) with ESMTPA id 34F35E4511; Fri, 17 Aug 2018 09:46:36 -0400 (EDT) Date: Fri, 17 Aug 2018 06:46:34 -0700 From: Andres Freund To: Alexis =?utf-8?B?TMOqLVF1w7Rj?= Cc: pgsql-performance@postgresql.org Subject: Re: Bi-modal streaming replication throughput Message-ID: <20180817134634.o7mfotigxxmy25yn@alap3.anarazel.de> References: <20180814174645.tkyxu27ophat3cqk@alap3.anarazel.de> <20180814175002.3peqbqnbd2kdtrzk@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 [.] 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