Apparently table locks are the key issue to see red flags.
As we observe, every time, red marking occurs, there must be some tables
are locked.
Can anyone shed light into this?
Regards,
David
On 3/16/22 15:15, Shaozhong SHI wrote:
Apparently table locks are the key issue to see red flags.
As we observe, every time, red marking occurs, there must be some tables
are locked.
Where do these red markings occur? (It is physically impossible for them to
occur in Postgresql because Po
On 3/16/22 13:15, Shaozhong SHI wrote:
Apparently table locks are the key issue to see red flags.
As we observe, every time, red marking occurs, there must be some tables
are locked.
Can anyone shed light into this?
Not with the information provided.
Needed info(and you should know this
Table locks present a barrier for progressing queries.
How to explicitly lock and unlock tables in pgsql, so that we can guarantee
the progress of running scripts?
Regards,
David
Em qua., 16 de mar. de 2022 às 17:30, Shaozhong SHI
escreveu:
> Table locks present a barrier for progressing queries.
>
> How to explicitly lock and unlock tables in pgsql, so that we can
> guarantee the progress of running scripts?
>
> Regards,
>
> David
>
Have a look at https://www.postgresql