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 Ian Axelrod
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 CA+B3G4TFzHmRt2odVjmGT7=3jeUzbcQLT8LcpZ6A5fAucSgPfg@mail.gmail.com
Whole thread Raw
In response to Re: A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
Thank you Laurenz,

I figured there was a high chance this is an Aurora-specific issue. I
do wonder if the replica lag itself is an Aurora-specific issue,
though the replica-reconnect feature is definitely Aurora-specific. I
will be in communication with AWS.

On Tue, May 6, 2025 at 6:28 AM Laurenz Albe <laurenz.albe@cybertec.at> 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 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: Jacob Champion
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER
Next
From: Sami Imseih
Date:
Subject: Re: queryId constant squashing does not support prepared statements