Re: postgres keeps having blocks - Mailing list pgsql-general

From Rob Sargent
Subject Re: postgres keeps having blocks
Date
Msg-id e7e1f867-559e-4804-88b0-4ca254458699@gmail.com
Whole thread Raw
In response to Re: postgres keeps having blocks  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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?




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: postgres keeps having blocks
Next
From: Bruce Momjian
Date:
Subject: Re: psql \du no more showing "member of" column