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 1n8lFv-00069V-KU for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jan 2022 15:46:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8lFs-00066o-8e for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jan 2022 15:46:12 +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 1n8lFr-00066f-Nw for pgsql-hackers@lists.postgresql.org; Sat, 15 Jan 2022 15:46:11 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n8lFk-0002FW-Hb for pgsql-hackers@postgresql.org; Sat, 15 Jan 2022 15:46:10 +0000 Received: by mail-io1-xd2c.google.com with SMTP id h23so15942342iol.11 for ; Sat, 15 Jan 2022 07:46:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=c4TXqe3e83GCEE62tCMsCtWZdYCetmdcVZovBj10c8c=; b=KSjNO14lw+LsHP3xeRTXM5gGkTs1ya4N0EbT7sUohyi30lRzRsdyErVaKElrR3UzjI RcAdsLt46jB5PXe1Fxqqx/FPATre+QtGpoPUJWBOoZ7+N4xHSquzBWxRa7/cpJl/F93M 6b8h0UK491wjLniFw2qr6Lhtt6Fi3APR9rjn+ducB+BtGEQIkGnXtOVZJBipeQR7w1ZG hMjS/cSxtCeAhh7yrKa2UD8fyRdFL+nU53h9n0t6pQU2FhXzvZprrbL8fUBopB3xL5Qd C5crK7E82nwEY1Ve7y8n/LBW6qYY5csM6vBFoOQvspYidWoTCk9lydB8qj7LU/cvdy7b KT4g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:content-transfer-encoding :in-reply-to:user-agent; bh=c4TXqe3e83GCEE62tCMsCtWZdYCetmdcVZovBj10c8c=; b=WpDVXNj60dgHNTinQaSOUaJ89gDyIiImNkYGgEwSd72KsxFf2yTQRz+qDX7Xa5tg/N BRnLVmpoJ3q1WZwlXVh+F3T2aTUYgfaXK6fdwS/PTOTqpkrp0nF+zfp4/epJRotCP635 7dBdu9HXV4M99AY5R/g7iw/MdUWflZiBeoY94V8w+aFH5f63zbsdlq9TVPCveIC/+d7Q FZ1THT0ac9+uPgsJgooqjFpEvTsB2aq69wK5yyokuQwoumxnpn6CbsLtlzhFz1CBHAHQ wbmRGVej1tHYNZZLW1xusBlgm/6WS3Z0n3ZxjRYbk4E7Y+kddGKWNXW29/u90/yP+mf3 HA5A== X-Gm-Message-State: AOAM533bA5JyN+QoYCF8mqEsfNUKg1WDuwbROFHfPgoywdXraSSHC02v 0bzfwVe40v7IRKUCw08QV0gvKg== X-Google-Smtp-Source: ABdhPJxq0qAmJ9rnstJzRYMwhTWt5LqXOSsyZ4+3o0cc3qJ35bcdB82gd3q2sj1NM4czE/uV3jCgOQ== X-Received: by 2002:a5e:c805:: with SMTP id y5mr5803514iol.210.1642261563185; Sat, 15 Jan 2022 07:46:03 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id p16sm7199269iov.3.2022.01.15.07.46.02 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 15 Jan 2022 07:46:02 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id AA12A800783; Sat, 15 Jan 2022 09:46:01 -0600 (CST) Date: Sat, 15 Jan 2022 09:46:01 -0600 From: Justin Pryzby To: Andrey Borodin Cc: Shawn Debnath , Julien Rouhaud , Gilles Darold , Tomas Vondra , Tomas Vondra , Alexander Korotkov , Anastasia Lubennikova , Daniel Gustafsson , Kyotaro Horiguchi , Thomas Munro , pgsql-hackers@postgresql.org Subject: Re: MultiXact/SLRU buffers configuration Message-ID: <20220115154601.GT14051@telsasoft.com> References: <15CA416B-3446-462D-902B-4883DD3ADEE6@yandex-team.ru> <494C5E7F-E410-48FA-A93E-F7723D859561@yandex-team.ru> <28051640513399@vla1-36b7415cbc1b.qloud-c.yandex.net> <20220114092838.gbr6ea7zxbaespsr@jrouhaud> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Jan 15, 2022 at 12:16:59PM +0500, Andrey Borodin wrote: > > 15 янв. 2022 г., в 03:20, Shawn Debnath написал(а): > > On Fri, Jan 14, 2022 at 05:28:38PM +0800, Julien Rouhaud wrote: > >>> PFA rebase of the patchset. Also I've added a patch to combine > >>> page_number, page_status, and page_dirty together to touch less > >>> cachelines. > >> > >> The cfbot reports some errors on the latest version of the patch: > >> > >> https://cirrus-ci.com/task/6121317215764480 > >> [...] > >> Could you send a new version? In the meantime I will switch the patch > >> status to Waiting on Author. > > > > I was planning on running a set of stress tests on these patches. Could > > we confirm which ones we plan to include in the commitfest? > > Many thanks for your interest. Here's the latest version. This is failing to compile under linux and windows due to bitfield syntax. http://cfbot.cputube.org/andrey-borodin.html And compile warnings: slru.c: In function ‘SlruAdjustNSlots’: slru.c:161:2: warning: ISO C90 forbids mixed declarations and code [-Wdeclaration-after-statement] 161 | int nbanks = 1; | ^~~ slru.c: In function ‘SimpleLruReadPage_ReadOnly’: slru.c:530:2: warning: ISO C90 forbids mixed declarations and code [-Wdeclaration-after-statement] 530 | int bankstart = (pageno & shared->bank_mask) * shared->bank_size; | ^~~ Note that you can test the CI result using any github account without waiting for the cfbot. See ./src/tools/ci/README. -- Justin