Request a Demo
Home   >   mailing lists

Re: pg_buffercache: Add per-relation summary stats - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_buffercache: Add per-relation summary stats
Date
Msg-id CA+TgmobD9zBt=UPbkM4kuEKw8OhQRN-tVKTwKkXUZfH-J0_8uQ@mail.gmail.com
Whole thread
In response to Re: pg_buffercache: Add per-relation summary stats  (Khoa Nguyen <kdnguyen9.oss@gmail.com>)
Responses Re: pg_buffercache: Add per-relation summary stats
List pgsql-hackers
Tree view 
On Thu, Jul 9, 2026 at 2:58 PM Khoa Nguyen <kdnguyen9.oss@gmail.com> 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

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: SQL/JSON json_table plan clause
Next
From: Thom Brown
Date:
Subject: Re: SQL/JSON json_table plan clause