How do we measure queries per second (QPS), not transactions per second, in
PostgreSQL without turning on full logging which has a performance penalty
and can soak up lots of disk space?
We are using 8.4, but I'm interested in any version as well.
Thank you,
Adam C. Scott
The "simple" case may be anti-virus or firewall blocking feeding into the
database. Be sure to check windows system logs for any unusual messages.
Check the postgres log (usually in PGDATA/pg_logs)
For seeing disk I/O on Win7 check out
http://www.digitalcitizen.life/how-use-resource-monitor-wind
