"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