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 1nAhex-00036y-LP for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jan 2022 00:20:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAhew-0007fQ-6d for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jan 2022 00:20:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAhev-0007fH-QF for pgsql-hackers@lists.postgresql.org; Fri, 21 Jan 2022 00:20:05 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAhep-0005Fd-6q for pgsql-hackers@postgresql.org; Fri, 21 Jan 2022 00:20:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1642724400; x=1674260400; h=date:from:to:cc:message-id:references:mime-version: content-transfer-encoding:in-reply-to:subject; bh=RJOdOxmfv8FpA1PWiXW4OZJZx8kFfvy32edR89RSeGk=; b=Pqr06IqknsMuIwP7axH0jcIeTcxsgKBesr3jYCXosFJevTIWniJljWD7 Gjlw2Mn0QGW01AV/PwcYjG2MP0DwRy7bSC4U4o2XPHhiEIBnd4OBVIwHQ i0eKpky15Uyr7/Wpqm3zarGCHFniKT/yCBOjqUfNt6jCI4Bi+sm2AMEWK 8=; X-IronPort-AV: E=Sophos;i="5.88,303,1635206400"; d="scan'208";a="56880366" Subject: Re: MultiXact\SLRU buffers configuration Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-iad-1d-35b1f9a2.us-east-1.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 21 Jan 2022 00:19:55 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan2.iad.amazon.com [10.40.163.34]) by email-inbound-relay-iad-1d-35b1f9a2.us-east-1.amazon.com (Postfix) with ESMTPS id 8E07A200022; Fri, 21 Jan 2022 00:19:51 +0000 (UTC) Received: from EX13D05UWC002.ant.amazon.com (10.43.162.92) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.28; Fri, 21 Jan 2022 00:19:51 +0000 Received: from f01898859afd.ant.amazon.com (10.43.162.203) by EX13D05UWC002.ant.amazon.com (10.43.162.92) with Microsoft SMTP Server (TLS) id 15.0.1497.28; Fri, 21 Jan 2022 00:19:50 +0000 Date: Thu, 20 Jan 2022 16:19:49 -0800 From: Shawn Debnath To: Andrey Borodin CC: Julien Rouhaud , Gilles Darold , Tomas Vondra , Tomas Vondra , Alexander Korotkov , Anastasia Lubennikova , Daniel Gustafsson , Kyotaro Horiguchi , pgsql-hackers , Thomas Munro Message-ID: References: <494C5E7F-E410-48FA-A93E-F7723D859561@yandex-team.ru> <28051640513399@vla1-36b7415cbc1b.qloud-c.yandex.net> <20220114092838.gbr6ea7zxbaespsr@jrouhaud> <990B810E-8944-4749-A820-4F46A8CB8502@yandex-team.ru> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <990B810E-8944-4749-A820-4F46A8CB8502@yandex-team.ru> X-Originating-IP: [10.43.162.203] X-ClientProxiedBy: EX13D12UWA002.ant.amazon.com (10.43.160.88) To EX13D05UWC002.ant.amazon.com (10.43.162.92) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jan 20, 2022 at 09:21:24PM +0500, Andrey Borodin wrote: > CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you can confirm the sender and know the content is safe. > > > 20 янв. 2022 г., в 20:44, Shawn Debnath написал(а): > Can you please also test 2nd patch against a large multixact SLRUs? > 2nd patch is not intended to do make thing better on default buffer sizes. It must save the perfromance in case of really huge SLRU buffers. Test was performed on 128/256 for multixact offset/members cache as stated in my previous email. Sure I can test it for higher values - but what's a real world value that would make sense? We have been using this configuration successfully for a few of our customers that ran into MultiXact contention. -- Shawn Debnath Amazon Web Services (AWS)