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
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
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
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
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
