Deadlock detected while executing concurrent insert queries on same table

2025-03-31 Thread Sri Keerthi
Hello community, I recently encountered a deadlock in postgresql while performing concurrent INSERT statements on the same table in two separate sessions. The error message explicitly mentions that the deadlock occurred while inserting an index tuple. There were no explicit transactions (BEGIN/

Deadlock detected while executing concurrent insert queries on same table

2025-03-26 Thread Sri Keerthi
Hello community, I recently encountered a deadlock in postgresql while performing concurrent INSERT statements on the same table in two separate sessions. The error message explicitly mentions that the deadlock occurred while inserting an index tuple. There were no explicit transactions (BEGIN/