Thread: Apparently table locks are the key issue to see red flags
Need more detail on this. Locks are generally caused by long updates or writes or perhaps a hung transaction. Can you reply with a bit more detail of what you are seeing, perhaps pg_stat_activity list?
Rule of thumb for high trx environments is to batch updates especially for larger tables to avoid excessive locking.
Rule of thumb for high trx environments is to batch updates especially for larger tables to avoid excessive locking.
On Wed, Mar 16, 2022 at 4:32 PM Shaozhong SHI <shishaozhong@gmail.com> 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?Regards,David
Jayson Hreczuck | Principal Database Administrator
C: +1 617.571.9861
130 Turner St, Ste 530, Waltham, MA 02453