[GENERAL] troubleshooting a database that keeps locking up

I have a database that has started to constantly hang after a brief period of activity looking at `select * from pg_stat_activity;` I roughly see the following each time: process 1 | IDLE process 2 | IDLE in transaction process 3 | IDLE in transaction process 4

Re: [GENERAL] troubleshooting a database that keeps locking up

Jonathan Vanasco postg...@2xlp.com writes: I have a database that has started to constantly hang after a brief period of activity looking at `select * from pg_stat_activity;` I roughly see the following each time: process 1 | IDLE process 2 | IDLE in transaction