Re: A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.

Laurenz Albe wrote: > > On Mon, 2025-05-05 at 23:52 -0500, Ian Axelrod wrote: > > This issue occurred on an AWS RDS Aurora PostgreSQL installation. > > Aurora is different from PostgreSQL. In particular, the query cancellation > error you are showing does not occur in the Post

A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.

Hi, I help administrate a set of reasonably large PostgreSQL* database servers at my current place of employment. Late last week, there was a serious failure on one of the replicas for my employer's largest database server. I have not seen a failure like this in 10 years of working heavily with Po