public inbox for [email protected]
help / color / mirror / Atom feedFrom: Robert Haas <[email protected]>
To: Khoa Nguyen <[email protected]>
Cc: Tomas Vondra <[email protected]>
Cc: Ashutosh Bapat <[email protected]>
Cc: Masahiko Sawada <[email protected]>
Cc: Lukas Fittl <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: Paul A Jungwirth <[email protected]>
Cc: Khoa Nguyen <[email protected]>
Subject: Re: pg_buffercache: Add per-relation summary stats
Date: Thu, 9 Jul 2026 16:05:11 -0400
Message-ID: <CA+TgmobD9zBt=UPbkM4kuEKw8OhQRN-tVKTwKkXUZfH-J0_8uQ@mail.gmail.com> (raw)
In-Reply-To: <CAONt3B0HS=HKC8QkCo5LdYxCxh19xXk6=JA79a-w-1ji+i8y5w@mail.gmail.com>
References: <CAP53Pkx0=ph0vG_M20yVAoK11yGSTZP=53-rZt36OCP4hBPaDQ@mail.gmail.com>
<CAD21AoCKz0t06-qOOm_7kgMn=Niu0yYB3R5jhOY0oVb=5AWytA@mail.gmail.com>
<CAExHW5uqQuPNEjj2ondemCYdtFHExm=jvw-4naPn7gdMmkhrgw@mail.gmail.com>
<CAP53PkyK65PM-Ws7ctj5-eKqVxHo5FzoWKW7=XPq5Jc1qZCJNg@mail.gmail.com>
<CAD21AoCzv5q89VDZ=Ot1wWguBO0MGdCc0-NXN83-Jg57uiJN1Q@mail.gmail.com>
<CAExHW5tynt3Vmmhvvk929Ljfz6jTaJWWoRDthhV=e13GvYRSqQ@mail.gmail.com>
<[email protected]>
<CA+Tgmob_ooei61owb21CbLmAz=CTAFRrTSmXkwT1eg1=CDP_UQ@mail.gmail.com>
<CAONt3B0HS=HKC8QkCo5LdYxCxh19xXk6=JA79a-w-1ji+i8y5w@mail.gmail.com>
On Thu, Jul 9, 2026 at 2:58 PM Khoa Nguyen <[email protected]> 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
view thread (9+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: pg_buffercache: Add per-relation summary stats
In-Reply-To: <CA+TgmobD9zBt=UPbkM4kuEKw8OhQRN-tVKTwKkXUZfH-J0_8uQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox