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