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