AW: What do you do with a long running rollback

Hi Tom,

do you see heavy disk activity?

best,

A

-----Ursprüngliche Nachricht-----
Von: Tom Lane <tgl@sss.pgh.pa.us>
Gesendet: Freitag, 26. November 2021 19:42
An: Chris Cawley <cj_cawley@yahoo.com>
Cc: pgsql-admin@lists.postgresql.org
Betreff: Re: What do you do with a long running rollback

Chris Cawley <cj_cawley@yahoo.com> writes:
> It's been like that for several days already.

Really?  Rollback is O(1) in Postgres.

I could possibly believe that it's blocked on a lock, but even that would be a bug, because transaction abort should
nevertry to take any new locks. 

A perhaps-more-plausible theory is that you've enabled synchronous commit but your replica is failing to ack the
transmissionof the abort's WAL record. 

What are you looking at exactly?

            regards, tom lane