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

Поиск
Список
Период
Сортировка
От 高荣祥
Тема autovacuum worker process use high cpu and stuck for a long time
Дата
Msg-id 2a175961.ff1a.14ed9037e6c.Coremail.gaorx08@163.com
обсуждение исходный текст
Список pgsql-bugs
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!


Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Niall Ross
Дата:
Сообщение: Re: BUG #13518: CancelRequest lacks statement identifier
Следующее
От: kumarsathishms@gmail.com
Дата:
Сообщение: BUG #13525: Database crashed with several error messages "Could not open file "pg_multixact/members/"