transaction blocking on COMMIT

From: Bob Jolliffe <bobjolliffe(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: transaction blocking on COMMIT
Date: 2021-05-24 11:30:19
Message-ID: CACd=f9eVoGm513TJffepBB7pWAamH3GBh+G=BrPZjT0AiTscWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I am seeing a strange issue on a database using jdbc. Regularly, 4 or
5 times a day, I see something like a "stutter", where a bundle of
maybe 30 transactions suddenly finish at the same time. It looks like
(it is quite hard to catch this exactly) that the lead transaction
which has been blocking the rest has been blocked in COMMIT. In each
case it blocks for almost exactly 30s, just over, and once it goes
through, releases locks, and the others clear behind it.

My question: what are the range of possibilities that might cause a
COMMIT to block? I haven't seen this before. Is there anything
suspicious about the regular 30s? Occasionally we see 60s, which
seems likely to be two sets of 30.

Regards
Bob

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vijaykumar Jain 2021-05-24 11:35:32 Re: transaction blocking on COMMIT
Previous Message Michel SALAIS 2021-05-22 05:41:43 RE: Partition with check constraint with "like"