On 2021-Jun-06, Justin Pryzby wrote: > However, I also found an autovacuum chewing 100% CPU, and it appears the > problem is actually because autovacuum has locked a page of pg-statistic, and > every other process then gets stuck waiting in the planner. I checked a few > and found these:
> [...] Hmm ... I wonder if this could be related to commits d9d076222f5b, c98763bf51bf, etc. I don't have any connecting thoughts other than the tuple visibility code being involved. Do you see any procs with the PROC_IN_SAFE_IC flag set? -- Álvaro Herrera 39°49'30"S 73°17'W