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 09:31:00
Message-ID: CA+hUKGJ53Nghv5XdPKmOpmUb3zcYUF9DzBXB_S5Q030t6pBLiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

> #0 ensure_record_cache_typmod_slot_exists (typmod=0) at typcache.c:1714

Are you able to print out the value of global variable
RecordCacheArrayLen? I wonder if this loop in
ensure_record_cache_typmod_slot_exists() is not terminating:

int32 newlen = RecordCacheArrayLen * 2;

while (typmod >= newlen)
newlen *= 2;

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message James Pang (chaolpan) 2023-09-07 09:38:15 RE: FW: query pg_stat_ssl hang 100%cpu
Previous Message James Pang (chaolpan) 2023-09-07 08:54:09 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 09:38:15 RE: FW: query pg_stat_ssl hang 100%cpu
Previous Message James Pang (chaolpan) 2023-09-07 08:54:09 RE: FW: query pg_stat_ssl hang 100%cpu