Re: How to explicitly lock and unlock tables in pgsql?

2022-03-16 Thread Fabrízio de Royes Mello 
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.org/docs/current/sql-lock.html

-- 
Fabrízio Mello

Consultor
fabri...@timbira.com.br
https://www.timbira.com.br/
[image: facebook] 
[image: twitter] 
[image: linkedin] 
[image: instagram]

How to explicitly lock and unlock tables in pgsql?

2022-03-16 Thread Shaozhong SHI 
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

Re: Apparently table locks are the key issue to see red flags

2022-03-16 Thread Adrian Klaver 

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 by now):

1) Postgres version

2) Definition of red flags?

3) How do you observe the tables locked?

4) The results of the process you use in 3)



Regards,

David



--
Adrian Klaver
adrian.kla...@aklaver.com

Re: Apparently table locks are the key issue to see red flags

2022-03-16 Thread Ron 

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 Postgresql is a daemon, and therefore does not 
have a GUI.)


--
Angular momentum makes the world go 'round.

Apparently table locks are the key issue to see red flags

2022-03-16 Thread Shaozhong SHI 
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