Jimit Amin wrote:
> I have heavy transaction load production database 9.3 PPAS .Today Database is
> not able to give new
> process. I checked pg_stat_activity , there are so many transaction in
> waiting stage because of one
> procedure and lock on one table (Code inside procedure)
[...]
> co
On 07/04/2015 12:19 PM, Jimit Amin wrote:
ello,
I have heavy transaction load production database 9.3 PPAS .Today
Database is not able to give new process. I checked pg_stat_activity ,
there are so many transaction in waiting stage because of one procedure
and lock on one table (Code inside pro
ello,
I have heavy transaction load production database 9.3 PPAS .Today Database
is not able to give new process. I checked pg_stat_activity , there are so
many transaction in waiting stage because of one procedure and lock on one
table (Code inside procedure)
SELECT cnt
FROM tabl
