Re: Prevent locked state (row lock + alter table)

[Durumdara <durumdara@xxxxxxxxx>]

Hello!

We have found some solutions here:

https://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql#.W-7bFEeYWHs

https://dba.stackexchange.com/questions/132851/database-frozen-on-alter-table

Best regards

    dd

Durumdara <durumdara@xxxxxxxxx> ezt írta (időpont: 2018. okt. 5., P, 14:55):

Dear Members!

We have a big database somewhere with more than 150 active connection.

Sometimes we experienced a "lock" situation, the client's and programs are halted on a point.