Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfM3Y-0005ib-Ou for pgsql-performance@arkaria.postgresql.org; Wed, 18 Nov 2020 11:55:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kfM31-0004Kr-Ln for pgsql-performance@arkaria.postgresql.org; Wed, 18 Nov 2020 11:54:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfM30-0004Kj-3i for pgsql-performance@lists.postgresql.org; Wed, 18 Nov 2020 11:54:51 +0000 Received: from [64.147.123.24] (helo=wout1-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfM2x-0008U8-7r for pgsql-performance@postgresql.org; Wed, 18 Nov 2020 11:54:49 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id B5F0EFC0; Wed, 18 Nov 2020 06:54:35 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Wed, 18 Nov 2020 06:54:35 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=imap.cc; h=to:cc :references:subject:from:message-id:date:mime-version :content-type; s=fm1; bh=QOSddd9kNrsZZa7JLneabDnT+nKizgWfq+B2QRZ Ua80=; b=MW0Fdnas/62Q4TIHIwVY1OmcW9ezgke6xmLUbio6pCRx782tdHz9Ql3 ruZAROEy9oqFDFmyPQSuDg3KXWc8mZu7jXOSzoC1KlQgXNarnJxvJIuH3TXogClN CNwFrC1GJxXKvFVYVMK73ZugtgzpkNm4LiEGbCqyO9GVd9TSOuJl2ri5S3Z1TFhG uSFI6BgkPYDrxXDF4HzRidW9zNQ3ySMuEGPKxfZ3pJC58e1bpIX8y1zSPsS+LbQa M2xkyPW8Jko92tKk70ImynSlpKeJ3H5byFAE4RGjxzNbBY/pIhtd9UdORmrTgddx xbvYNJZdktkkupdLowpKE8T0TlqIRKA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:message-id :mime-version:references:subject:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=QOSddd9kNrsZZa7JL neabDnT+nKizgWfq+B2QRZUa80=; b=L8XBXChmPTN2F/J2MigoOSbOU15pKJj0D Y/sq+SPXXrFtPlliAQHykmnuGyjVk9UnlGQyXlBDnhWALh4pIn/NM8l13V95mOOL +81TRVGTz0rPTtwO4+aILHq8ydHWbAK83Wtmnv5enF4f+08e9MXcGdcUTMszbQll R+tvdTs+KBL6s/YI0rzwQ3PLMxE7RuKN+tesZqDmWo/q7kojVgCMP0IcIbewVmqf IGz3h/WSdmyGZE0/zGWTPcGLsZNgrxpl/TgAnoGaNOEMwpWIq/PqtQULR9SW6ybk dT3/9fB9zHK4A8v6g+nkZBRtC9gnTeEUAnxQVgqAfusCobtlawKIA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudefhedgfeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdlfedtmdenogetfedtuddqtd duucdludehmdenucfjughrpefvfhfuhffkffgfgggtsegrtderredtfeejnecuhfhrohhm peetlhgvgigvhicuuegrshhhthgrnhhovhcuoegsrghshhhtrghnohhvsehimhgrphdrtg gtqeenucggtffrrghtthgvrhhnpeeukedvleegueffudevudekudfhudelkeetgeetgfeu jeevieetvdegjedvveetveenucfkphepledvrdduvddrvddrvdeknecuvehluhhsthgvrh fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepsggrshhhthgrnhhovhesihhm rghprdgttg X-ME-Proxy: Received: from ev9d9.btn1.brandwatch.net (host-92-12-2-28.as43234.net [92.12.2.28]) by mail.messagingengine.com (Postfix) with ESMTPA id D33833064AB3; Wed, 18 Nov 2020 06:54:34 -0500 (EST) To: bashtanov@imap.cc Cc: pgsql-performance@postgresql.org References: Subject: Re: How to prioritise walsender reading from pg_wal over WAL writes? From: Alexey Bashtanov Message-ID: <774ec1b8-c7c6-cfa2-098d-5c6a32dcfc1a@imap.cc> Date: Wed, 18 Nov 2020 11:54:33 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------5027913C0139905581AE70AC" Content-Language: en-US X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.24 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------5027913C0139905581AE70AC Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit If it helps, here's the details of the hardware config. The controller is |AVAGO MegaRAID SAS 9361-4i|, the SSDs are |INTEL SSDSC2KG960G8| (configured as a raid1). Current scheduler used is deadline. Currently XFS is mounted without nobarriers, but I'm going to set that when there's high load next time to see how it affects throughput. Properties of the array VD6 Properties : ============== Strip Size = 256 KB Number of Blocks = 1874329600 VD has Emulated PD = Yes Span Depth = 1 Number of Drives Per Span = 2 Write Cache(initial setting) = WriteBack Disk Cache Policy = Disk's Default Encryption = None Data Protection = Disabled Active Operations = None Exposed to OS = Yes Creation Date = 28-10-2020 Creation Time = 05:17:16 PM Emulation type = default Cachebypass size = Cachebypass-64k Cachebypass Mode = Cachebypass Intelligent Is LD Ready for OS Requests = Yes SCSI NAA Id = 600605b00af03650272c641ca30c3196 Best, Alex --------------5027913C0139905581AE70AC Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
If it helps, here's the details of the hardware config.
The controller is AVAGO MegaRAID SAS 9361-4i,
the SSDs are INTEL SSDSC2KG960G8 (configured as a raid1).
Current scheduler used is deadline.
Currently XFS is mounted without nobarriers, but I'm going to set that when there's high load next time to see how it affects throughput.

Properties of the array
VD6 Properties :
==============
Strip Size = 256 KB
Number of Blocks = 1874329600
VD has Emulated PD = Yes
Span Depth = 1
Number of Drives Per Span = 2
Write Cache(initial setting) = WriteBack
Disk Cache Policy = Disk's Default
Encryption = None
Data Protection = Disabled
Active Operations = None
Exposed to OS = Yes
Creation Date = 28-10-2020
Creation Time = 05:17:16 PM
Emulation type = default
Cachebypass size = Cachebypass-64k
Cachebypass Mode = Cachebypass Intelligent
Is LD Ready for OS Requests = Yes
SCSI NAA Id = 600605b00af03650272c641ca30c3196

Best, Alex
--------------5027913C0139905581AE70AC--