From: 高荣祥 <gaorx08@163.com>
To: pgsql-bugs@postgresql.org
Subject: autovacuum worker process use high cpu and stuck for a long time
Date: Wed, 29 Jul 2015 16:52:41 +0800 (CST)
Message-ID: <2a175961.ff1a.14ed9037e6c.Coremail.gaorx08@163.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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!
Attachments:63d0f703918fa0ec0e6e720f209759ee3d6ddb02.png (image/png, 23.3K) downloadview image962bd40735fae6cdc02dbc6309b30f2442a70f12.png (image/png, 10.6K) downloadview imagea686c9177f3e67095aca54fd3dc79f3df9dc55ed.png (image/png, 16.1K) downloadview image截图1.png (image/png, 143.5K) downloadview image截图2.png (image/png, 143.5K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: gaorx08@163.com
Subject: Re: autovacuum worker process use high cpu and stuck for a long time
In-Reply-To: <2a175961.ff1a.14ed9037e6c.Coremail.gaorx08@163.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox