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
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
