Re: [PERFORM] Long running transactions again ...

2007-04-18 Thread Jim C. Nasby
On Wed, Apr 11, 2007 at 12:50:37AM +0200, Tobias Brox wrote: We had problems again, caused by long running transactions. I'm monitoring the pg_stat_activity view, checking the query_start of all requests that are not idle - but this one slipped under the radar as the application was running

[PERFORM] Long running transactions again ...

2007-04-10 Thread Tobias Brox
We had problems again, caused by long running transactions. I'm monitoring the pg_stat_activity view, checking the query_start of all requests that are not idle - but this one slipped under the radar as the application was running frequent queries towards the database. That's not what concerns