On 10/18/23 10:15, Adrian Klaver wrote:
On 10/18/23 04:27, Shaozhong SHI wrote:My postgres is playing up. I terminated session that is causing blocks many time. New block appears. Endless. What should I do?Provide more information. 1) Postgres version. 2) Define what blocks means. 3) Show us the statements/code that is causing the issue. 4) Post relevant sections from the Postgres log.
Commit your transactions?