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

From: Durumdara <durumdara(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Prevent locked state (row lock + alter table)
Date: 2018-11-16 15:01:30
Message-ID: CAEcMXhmczy1OEb4CPU6WhuOg2jtr1OJNd7u+xW33-ydmFCycUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com> 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.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2018-11-16 15:55:58 Re: BDR and PostgreSQL 12 and Windows support
Previous Message Igor Neyman 2018-11-16 14:54:55 RE: BDR and PostgreSQL 12 and Windows support