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 1nNRNX-0005a6-Pc for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Feb 2022 03:34:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nNRNV-0000xL-Vw for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Feb 2022 03:34:45 +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 1nNRNV-0000xC-BN for pgsql-hackers@lists.postgresql.org; Fri, 25 Feb 2022 03:34:45 +0000 Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nNRNR-000871-1N for pgsql-hackers@postgresql.org; Fri, 25 Feb 2022 03:34:44 +0000 Received: by mail-oo1-xc29.google.com with SMTP id w10-20020a4ae08a000000b0031bdf7a6d76so4622716oos.10 for ; Thu, 24 Feb 2022 19:34:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=cPgiPECPXsNUemSOdsGcJwE/Q7NyQ6JPEJjwyqRAQbU=; b=mpkaeB0EUQWIcY2teyuV01zDrjq5APil25LYEjgcHAcdJlVs3mByCqtfIZWYyL4Edw A9+x7N4JuKkFDuE+JKon0iHARNyCM3ogIUZ0We78JbhaTgFokZIdbHrCd6+IE8TM6dsP ZiUqR8MiH8WEljZLkTchJVz5MztGdW3XPmHWSul2qh5fFW0hyIIzzPIUdCF9Z69pgSNg qWkbhappnL1hPgRgHvVh02VjamM4qtjrf2HWiFFVSBFJDfyyHWoGuLzjiTBlvIy/esQN y/G2SqtUD3vHIHlmRRUcPLgwWawiT+k0bYru7QZkfEFfFXQnjRBotqE5bamD2w8mpIx5 G6dA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=cPgiPECPXsNUemSOdsGcJwE/Q7NyQ6JPEJjwyqRAQbU=; b=c4LQb/CNHjYmzG4Uy+7o+MSJEeCGxVoPTIUXYhlvPHXbn5QTJP0cnpeo/S/RKz6pUk auqfUJ+4iwA81zE/KjtU4tiRcDntMtDKrVXIhs1v9Hwdlav6RV0Hq+S6q1aIir4yjTc3 4DrXmRoIgt432j+KyfPhc88V0CcKFH4qkfVYOBS4PMYlgcvzxb1V3/OCViJRmDIb9OvK IbOwoJufVSC56WV4vT0Vpc+GHcERx0+Y1JLtZu0RYzg2ZqpOGgScIzlvYqhc6QhL66zp pl4Vg7MyvTzmUocOu1E3+iXZ4wog6BmXptAad+Wc03TK1w5xANovr3pdUtbi37gi2doP 2Kdw== X-Gm-Message-State: AOAM531DXdp93sDproDyG0C/6Tsx7zNIovhno26iwhbsW9gofy8fyFns Rxrbxw+BFjgKHZ3XhWX49wm7YMdnYogg3i3lzb+A7dL3ZmzTR/BdS21lp0wtrWXyEMxsXyMAOAr rY0p4p9MpNKSb0VJDRqMQxDHimKzKm87xmLgtn4XqPVhx8WqkPbAUwMVcbzdKR62yVzbEfn2Tlh Q6HBYgRxnlbjgIeMWX5FjItN1FKjPgCzOfXuH95jKiqdNbOVyhMQHp X-Google-Smtp-Source: ABdhPJytgiqoQBU1kXjzK6ZDoP2O98yCK5xJOGnuUYYW7I56WIbaoAUuG/qAaaio9FswF3XR3ZclCJg6WrxJf4GOVuw= X-Received: by 2002:a05:6871:409c:b0:d6:def6:b619 with SMTP id kz28-20020a056871409c00b000d6def6b619mr546760oab.40.1645760078571; Thu, 24 Feb 2022 19:34:38 -0800 (PST) MIME-Version: 1.0 References: <20220225.102025.173579582113640633.horikyota.ntt@gmail.com> In-Reply-To: <20220225.102025.173579582113640633.horikyota.ntt@gmail.com> From: Simon Riggs Date: Fri, 25 Feb 2022 03:34:27 +0000 Message-ID: Subject: Re: Buffer Manager and Contention To: Kyotaro Horiguchi Cc: Yura Sokolov , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 25 Feb 2022 at 01:20, Kyotaro Horiguchi wrote: > Yura Sokolov is proposing a patch to separte the two partition locks. > > https://www.postgresql.org/message-id/1edbb61981fe1d99c3f20e3d56d6c88999f4227c.camel%40postgrespro.ru > > And it seems to me viable for me and a benchmarking in the thread > showed a good result. I'd appreciate your input on that thread. Certainly, I will stop this thread and contribute to Yura's thread. -- Simon Riggs http://www.EnterpriseDB.com/