Re: Pg stuck at 100% cpu, for multiple days

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers mailing list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pg stuck at 100% cpu, for multiple days
Date: 2021-08-31 11:40:18
Message-ID: 20210831114018.GA31515@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 31, 2021 at 04:00:14PM +0530, Amit Kapila wrote:
> One possibility could be there are quite a few DDLs happening in this
> application at some particular point in time which can lead to high

While not impossible, I'd rather say it's not very likely. We don't use
temporary tables, and while there are DB migrations, I don't think they
are often, and definitely don't take many days.

Best regards,

depesz

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2021-08-31 12:05:45 Re: Returning to Postgres community work
Previous Message Bharath Rupireddy 2021-08-31 11:17:22 Re: pg_receivewal starting position