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

From: 高荣祥 <gaorx08(at)163(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: autovacuum worker process use high cpu and stuck for a long time
Date: 2015-07-29 08:52:41
Message-ID: 2a175961.ff1a.14ed9037e6c.Coremail.gaorx08@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandeep Thakkar 2015-07-29 09:16:51 Re: BUG #13522: libtermcap.so: broken symbolic link to libncurses.so in PostgreSQL 9.4.4 binary distribution archive
Previous Message Venkata Balaji N 2015-07-29 00:02:31 Re: BUG #13521: refused connection to host and port