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

From Laurenz Albe
Subject Re: A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.
Date
Msg-id 3e709006f5bdf123bb0f5882099e299cbd48efb5.camel@cybertec.at
Whole thread Raw
In response to A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.  (Ian Axelrod <ian.axelrod@sentilink.com>)
Responses Re: A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.
List pgsql-hackers
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 PostgreSQL code base.  So unless
somebody who knows Aurora internals happens to read your question, you won't
get a good answer.

You could check if your I/O quota are exceeded...

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Fix slot synchronization with two_phase decoding enabled
Next
From: Amit Kapila
Date:
Subject: Re: Add an option to skip loading missing publication to avoid logical replication failure