Subject: Re: pg_buffercache: Add per-relation summary stats

From: Robert Haas <[email-masked]>
Date: Thu, 9 Jul 2026 16:05:11 -0400

On Thu, Jul 9, 2026 at 2:58 PM Khoa Nguyen <[email-masked]> wrote:
> I think erroring out when the
> estimated hash size exceeds work_mem is sufficient.  We can rely on
> the DBA’s call to increase this session’s work_mem for this 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.

-- 
Robert Haas
EDB: http://www.enterprisedb.com