From: Tom Lane <tgl@sss.pgh.pa.us>
To: downey.deng@postgresdata.com <downey.deng@postgresdata.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: cpu hight sy% usage
Date: Mon, 27 Feb 2017 23:37:49 -0500
Message-ID: <1474.1488256669@sss.pgh.pa.us> (raw)
In-Reply-To: <2017022723135372857425@postgresdata.com>
References: <2017022723135372857425@postgresdata.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
"downey.deng@postgresdata.com" <downey.deng@postgresdata.com> writes:
> i have PostgreSQL 9.5.3 server running on redhalt 6.6
> when i run one query with pgbench the cpu is 80% and sy% is 60%
If you were to provide a self-contained test case, people might take
some interest in this ... but nobody is going to spend time guessing
at all the details you didn't supply.
https://www.postgresql.org/docs/current/static/bug-reporting.htmlhttps://wiki.postgresql.org/wiki/Slow_Query_Questions
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, downey.deng@postgresdata.com, pgsql-general@postgresql.org
Subject: Re: cpu hight sy% usage
In-Reply-To: <1474.1488256669@sss.pgh.pa.us>
* 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