autovacuum worker process use high cpu and stuck for a long time - Mailing list pgsql-bugs

From 高荣祥
Subject autovacuum worker process use high cpu and stuck for a long time
Date
Msg-id 2a175961.ff1a.14ed9037e6c.Coremail.gaorx08@163.com
Whole thread Raw
List 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!


Attachment

pgsql-bugs by date:

Previous
From: Niall Ross
Date:
Subject: Re: BUG #13518: CancelRequest lacks statement identifier
Next
From: kumarsathishms@gmail.com
Date:
Subject: BUG #13525: Database crashed with several error messages "Could not open file "pg_multixact/members/"