Re: postgres keeps having blocks

2023-10-18 Thread Rob Sargent
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)

Re: postgres keeps having blocks

2023-10-18 Thread Adrian Klaver
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 causi

Re: postgres keeps having blocks

2023-10-18 Thread Ron
On 10/18/23 07:40, David G. Johnston wrote: On Wednesday, October 18, 2023, 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? PostgreSQL is probably just doing what you t

Re: postgres keeps having blocks

2023-10-18 Thread David G. Johnston
On Wednesday, October 18, 2023, 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? > PostgreSQL is probably just doing what you told it. Not possible to give advice without knowin

postgres keeps having blocks

2023-10-18 Thread Shaozhong SHI
My postgres is playing up. I terminated session that is causing blocks many time. New block appears. Endless. What should I do? Regards, David