Re: Performance issue on temporary relations

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tue, Aug 19, 2025 at 8:45 AM 章晨曦 <zhangchenxi@halodbtech.com> wrote:
>> Acturely, we just facing such problem in some real systems. More than 3,700
>> temporary tables created! I accept such case is not that common, but it
>> does exist.

> It is unfair to add a performance penalty to everyone just because some
> people write bad code.  I concur that adding complexity to the system to
> gracefully handle this corner-case doesn't seem justified.  A use case
> description, not mere existence, is needed to provide such justification.

Yeah, the real sub-text here is "should we believe that this
application is well designed?".  It sounds like a fairly brute-force
solution.

            regards, tom lane