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?