Re: FW: query pg_stat_ssl hang 100%cpu

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: FW: query pg_stat_ssl hang 100%cpu
Date: 2023-09-07 10:01:12
Message-ID: CA+hUKGJKXdMyLdqYDioVnAUiAE4GKdmxues61e+4nz5YHnmQkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

On Thu, Sep 7, 2023 at 9:38 PM James Pang (chaolpan) <chaolpan(at)cisco(dot)com> wrote:
> (gdb) p RecordCacheArrayLen
> $3 = 0

Clearly this system lacks check against wrapping around, but it must
be hard work to allocate billions of typmods...

Or maybe if in an earlier call we assigned RecordCacheArray but the
allocation of RecordIdentifierArray failed (a clue would be that it is
still NULL), we never manage to assign RecordCacheArrayLen a non-zero
value? But it must be unlikely for a small allocation to fail...

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message James Pang (chaolpan) 2023-09-07 10:31:25 RE: FW: query pg_stat_ssl hang 100%cpu
Previous Message James Pang (chaolpan) 2023-09-07 09:54:47 RE: FW: query pg_stat_ssl hang 100%cpu

Browse pgsql-performance by date

  From Date Subject
Next Message James Pang (chaolpan) 2023-09-07 10:31:25 RE: FW: query pg_stat_ssl hang 100%cpu
Previous Message James Pang (chaolpan) 2023-09-07 09:54:47 RE: FW: query pg_stat_ssl hang 100%cpu