On 10/18/23 07:40, David G. Johnston wrote:
On Wednesday, October 18, 2023, Shaozhong SHI <shishaozhong@gmail.com> wrote:
My postgres is playing up.
I terminated session that is causing blocks many time.
New block appears.
Endless.
What should I do?
PostgreSQL is probably just doing what you told it. Not possible to give advice without knowing what you told it to do. You should put more effort into showing others what your app is doing and how you are debugging it and the database.
Killing sessions without changing anything else is unlikely to result in a change of behavior.
That's the definition of insanity...
--
Born in Arizona, moved to Babylonia.