Обсуждение: autovacuum worker process use high cpu and stuck for a long time

Поиск
Список
Период
Сортировка

autovacuum worker process use high cpu and stuck for a long time

От
高荣祥
Дата:
Recently,i meet a problem about autovacuum
this option "autovacuum: ANALYZE pg_catalog.pg_attribute" has lasted for a long time, and the process, "postgres :autovacuum worker process  ngfw_log" is using a high cpu. this problem is only found in this table——“pg_attribute”,what‘s the problem and how can i solve it or research ?

this is my configure


and the gdb bt result


looking forward to your reply .
thanks!


Вложения