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.96) (envelope-from ) id 1whuzx-000ULr-2F for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 20:05:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whuzv-00EXAF-04 for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 20:05:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1whuzu-00EXA6-2P for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 20:05:27 +0000 Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1whuzt-00000000Mw8-1qYV for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 20:05:26 +0000 Received: by mail-ed1-x531.google.com with SMTP id 4fb4d7f45d1cf-698beff7178so348971a12.3 for ; Thu, 09 Jul 2026 13:05:25 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783627524; cv=none; d=google.com; s=arc-20260327; b=nwHAsSZ+sEORosrfjlSVjAXGNEGCbVu7ebL30T0SjbI604sdykWuNs9uo8MdsAsTL4 IEITNgWkJgANcBPBPtd6IoHxW8ARoIpw+YBkbOJ8xjBmNId1ISPvzMVHRerrl8laE4O9 uvf4rgrn2svfCUnpL/G9drho6optYMO00265ZZev9+EnsIF06dHl3qiRrZkxnC5xiIuQ ISAc9PRCuU6h3a5SkGUsZ21c5sZIo1uMHq85qI3QhwK80oO3KWlKTuhcBNE+wBYpOGC2 G0Gd+t7yYDgB9SmGbJJEp/JCjhmaox5anx1fVVO3iT4D6T4NejzLoZw2137wH4FeQPue xqJg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=rPwblm9BNBJNdqVXVCqlHjFehAAx5klGAacgUOVJ2/0=; fh=A92sZcHKCzqYZF4XxtD9rUxn3BJrdvLJpkHFqg2m1UE=; b=S2DgwwBuqG2QWqEsUS8PuGPNCUjTDwp1ZdmvDl30lWDZUWJD2jFMqRRw44oudl/D97 j478C1PpVgZkH2MnPM7XaAzhRw1WKisUQH/z+rV/Adwy4OZYoskJIt6X25V6wpMU5zvi Q1FpJ5OZY6h/CE/76Bo85RbMh6LUTo4COkqdINNOx83kRiRh+9Ir4fZwUdguYGY7FqcZ eRowKI7Byqbqth45LQSOXfesERm0d9HTbE3yIM++y5C7JXinDzcSefHOCgh0oPGvD7Fs zEJB6xoJlRw5KlEnVHw2+N60K/91EbW4x9X9BKE5kRhoPOm8Ce/tl5S81xkUw+VrK+la /crA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783627524; x=1784232324; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:from:to:cc:subject :date:message-id:reply-to:content-type; bh=rPwblm9BNBJNdqVXVCqlHjFehAAx5klGAacgUOVJ2/0=; b=RmCzb05hn2PL5vQLQJfiX9w395Kwc+42uYkaH+lsm7gE62XLxDo2IXmgTDLBWq9o4X k3kVo8/yQSy4hF0st7N1znioPrOI+MV7EvdXIX64dhYmjvDz/3kopyXI79gbGD1poe6u +++Gp8rBEn56aUITIvU81eqqlPYow8dRmiWC+WLhP7ePoaLog6LKI8sKhAVg9oIPkOUx yfMoZ+BqHMbBGWWH+M4x8udwhQF7K7+gTpGqRo+rbZnxXPYQ5g98r1tH8tMmxdATI1yP Wu75YF04zFTkHOb3pA3a4OS20jnL8EjfGPyY17T1H+h1qa2I9v5JcQzCEibZSI4MIZf8 r0TA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783627524; x=1784232324; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=rPwblm9BNBJNdqVXVCqlHjFehAAx5klGAacgUOVJ2/0=; b=DGcoq4SyuOPgs8bsPXNBiJ3qMbTKTQBk9ILJ0o3X3bBlZKZR4eeDoC8ZUU/QhW+1ak JGGOuP5V15BnrMS/8+a7H+pyW9EEtRv4UEvat4o9zw9Ii9lLGKs+mDJv6dmTGNL8BUof +T4duRfdPbBgUyDd3ekD9sBJinc6moNzH2uRQpK7q37CYS8M9od6aa9puySfJtk7SFAo DNf7i6BZSlNPOVNVrBz8ALWxvTAqBhWogptueuv5UVH4WQdx2yYb/nW+WmWtVRJugN/v iQhr7bWT2aprWapYPlVI1FOhbSIGvb8j2dJSHBpsKQQ1s0Vx8UGWWfyk09ct/yBJeQOw lQjg== X-Forwarded-Encrypted: i=1; AHgh+RoN/2hKTwDLLM3hXjfkk3mKaHfkddvi5H1kvbLzgF1mjBE0AYlcUWw6IHt4fsA6/Jglnion0/V4Ao50wg1m@lists.postgresql.org X-Gm-Message-State: AOJu0Yx/HeIFHVpoht6l4tgrE2rhn80Ho1XN+Mm1j9phk8rwz+s4tjYA ArqnpKJaviFG2T2TvlNZ2o+v5777BXXT6S3e7SYD7uCN4GI+J7ciYf2ICDyFvs6N6tyPxNU0Fvc w8KP+0iqXEqwLL343KIp1sYe7uF6WnSk= X-Gm-Gg: AfdE7cnus5XspvWUCRCH9J4puoZa+3Hxbjm/Dtao49/s0NAYE3TH5AkzxSWytmL0jx1 IScvAsysUVqzUAsd2z2wLYvHPq1Z0WtWDv+WT5PddGUQjzdJzwT2vuPfH0NKMEA/BPuxl+epsS1 h59gzuPlM78TPxjk6K12pnT2c7sM+nl6nJYQyxRzdmLucza2PXwaJTF2Koz2eptqajl9vkBgVVB qIKB6XdcJUWDPMxIURnIv0lgngKbxxgoZf5477HOzxMtompOP1AHU0jOfGhVvlP3JRlFhI6t+9M DWRJez4yVj5P9eoykdgqtemgg5z1iQ0= X-Received: by 2002:a17:907:c788:b0:c12:79aa:828c with SMTP id a640c23a62f3a-c15ce0ae64fmr329310966b.18.1783627524026; Thu, 09 Jul 2026 13:05:24 -0700 (PDT) MIME-Version: 1.0 References: <670b867e-6518-48b0-b7c2-bd5f10ab58c6@vondra.me> In-Reply-To: From: Robert Haas Date: Thu, 9 Jul 2026 16:05:11 -0400 X-Gm-Features: AVVi8CcpdeDHTkYmFF06eb2Q1Xk6flcpS6Sd5ij9an6wsiNd0AB3Zsa2mTvyumw Message-ID: Subject: Re: pg_buffercache: Add per-relation summary stats To: Khoa Nguyen Cc: Tomas Vondra , Ashutosh Bapat , Masahiko Sawada , Lukas Fittl , PostgreSQL Hackers , Paul A Jungwirth , Khoa Nguyen Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 9, 2026 at 2:58=E2=80=AFPM Khoa Nguyen wrote: > I think erroring out when the > estimated hash size exceeds work_mem is sufficient. We can rely on > the DBA=E2=80=99s call to increase this session=E2=80=99s work_mem for th= is particular > query to go through without affecting all backends. I am -1 on an error in that case. I would just document how much memory the function can potentially use. --=20 Robert Haas EDB: http://www.enterprisedb.com