s there a way to monitor active connections, or at least to report when they grow too much? (say, I have an 8-core system and want to track down if, and when, active connections grow over 80)
You can achieve that just running simple query like select count(*) from pg_stat_activity where state = 'active'