"downey.deng@xxxxxxxxxxxxxxxx" <downey.deng@xxxxxxxxxxxxxxxx> 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.html https://wiki.postgresql.org/wiki/Slow_Query_Questions regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
