hang on MultiXact suddenly.
>>
>> Alvaro Herrera 於 2024年9月10日週二 下午4:15寫道：
>>
>>> On 2024-Sep-10, Amine Tengilimoglu wrote:
>>>
>>> > Hi,
>>> >
>>> >I encountered this in a project we migrated to PostgreSQL
>>
Hi,
I encountered this in a project we migrated to PostgreSQL
before, and unfortunately, it’s a situation that completely degrades
performance. We identified the cause as savepoints being used excessively
and without control. Once they reduced the number of savepoints, the issue
wa
Hi;
It's normal to see locks on tables during queries. These are usually locks
used automatically by postgres as a result of the operations you perform on
your database. You should check the document for the lock modes postgres
uses.
Lock causes slowness if it causes other queries to wait. You ca
it depends on your cluster environment. you need to know how much wal is
created in checkpoint_timeout duration. for example your
checkpoint_timeout = 30 min, you need to measure how much wal is created in
30 minute. and then you can increase max_wal_size according to this size.
Atul Kumar , 1
