Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfXeZ-000neX-Bd for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Feb 2024 04:04:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rfXeX-00HRp0-BH for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Feb 2024 04:04:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfXeX-00HRos-20 for pgsql-hackers@lists.postgresql.org; Thu, 29 Feb 2024 04:04:13 +0000 Received: from mail-pg1-x52b.google.com ([2607:f8b0:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfXeU-001xJv-G3 for pgsql-hackers@lists.postgresql.org; Thu, 29 Feb 2024 04:04:12 +0000 Received: by mail-pg1-x52b.google.com with SMTP id 41be03b00d2f7-5d3907ff128so407421a12.3 for ; Wed, 28 Feb 2024 20:04:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1709179448; x=1709784248; darn=lists.postgresql.org; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:from:to:cc:subject :date:message-id:reply-to; bh=g2wMTNAnliMYHNTOcBI6ok6LI+1wVA9/0NDfO2+m+GA=; b=J+W5IA3RBnsD+iUYaxMsdgjqZvDkhKpqJ5Lff2exzNlY4VrEq2rxJThSndXR/qYV/b 4yJoMoOgGjSrgSd91MSm5Al4GSLdejZq0zJlFRj/BRV9XI2qpbTM1E/aQWzCXiKBC0qW q3BgzeTPCaJu1kzq+81ODKbg55ZxSKVcsUtBo8Q6Kjr/ZBUo3HtCVj0yB7Y+vkFR9T9C zJ8TfF0zoWabel79JS5xUdpNWy0Qc+0WHTv/RNg1XgboVeC3PZgult6zTMHTmzWIT24A qnh5EWjJAyYuJkV2+LxOBKJZDF1+PRss99b1GJ4jKu5fKW2wMKigbJka9bfllT/l7awZ wwfQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709179448; x=1709784248; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=g2wMTNAnliMYHNTOcBI6ok6LI+1wVA9/0NDfO2+m+GA=; b=pkIZNMc5hTXzza+pr+i4tHNNCkJlefCoxHW7i+Ws/IzH4k+SjXkhOsss2Rieis9i5v j3kkIBt9ixQMzePL7g0wSIZVQacXBM8D/raTHam85+ycQy8WkgyKkTTHFf4UbTS8ED+f 1YK41SeO5QaPp7LXBQEyRM6tq6xaBPpzJHQb7iQ5APP1iuQ+aNyyDJVAqWrB4AS83PFv TxO1k5/Gx+lZ+vthKurrh/9UpluhESg+bGKJKDSTInh9T0SE/dLwlURC0/YxzQxuS3aj OEyl7inCZKVMFZ7tV8Cp0QjFU3XJ2CN7Hd9KuV3AKorOUy+xmStGKVlezln44dIafpNn a1Lw== X-Forwarded-Encrypted: i=1; AJvYcCUHv+DKbUUk6hJ1Tm/0V9Mf+rsFHmr0wNM930lyVB7Wg6ASvReMLXOmvDp+WAguSIEwIJavNhxpST2nFD5mt8smCwYXhe4M9BOgdJ4BY7gbnxPU X-Gm-Message-State: AOJu0YxYViPDF5pBVGqy830b/4nXLdiy6SIrdBKX3jGb+QXwwLXwmL2j iAi9kAPrWxjT44Vli6G+l4yjlhNS5ueUu9Gt4qHPrUOio5necdS4 X-Google-Smtp-Source: AGHT+IHjWWJnkYUjvQI5Kw3D3ciKUzLGwj9TWC4pYneIajoe/4f/zjdVwm0V46C13ayPmZmxg28/dA== X-Received: by 2002:a17:90a:d796:b0:29a:e097:50b0 with SMTP id z22-20020a17090ad79600b0029ae09750b0mr1225042pju.34.1709179447774; Wed, 28 Feb 2024 20:04:07 -0800 (PST) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id sc11-20020a17090b510b00b00298c633bd5fsm2508555pjb.30.2024.02.28.20.04.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 28 Feb 2024 20:04:07 -0800 (PST) Date: Thu, 29 Feb 2024 13:04:04 +0900 (JST) Message-Id: <20240229.130404.1411153273308142188.horikyota.ntt@gmail.com> To: alvherre@alvh.no-ip.org Cc: x4mmm@yandex-team.ru, dilipbalaut@gmail.com, tndrwang@gmail.com, pgsql-hackers@lists.postgresql.org, tomas.vondra@enterprisedb.com Subject: Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock From: Kyotaro Horiguchi In-Reply-To: <202402271733.43375fmfpr2f@alvherre.pgsql> References: <202402271626.ilamiem7n3hl@alvherre.pgsql> <202402271733.43375fmfpr2f@alvherre.pgsql> User-Agent: Mew version 6.8 on Emacs 27.2 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk At Tue, 27 Feb 2024 18:33:18 +0100, Alvaro Herrera wrote in > Here's the complete set, with these two names using the singular. The commit by the second patch added several GUC descriptions: > Sets the size of the dedicated buffer pool used for the commit timestamp cache. Some of them, commit_timestamp_buffers, transaction_buffers, subtransaction_buffers use 0 to mean auto-tuning based on shared-buffer size. I think it's worth adding an extra_desc such as "0 to automatically determine this value based on the shared buffer size". regards. -- Kyotaro Horiguchi NTT Open Source Software Center