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

Поиск
Список
Период
Сортировка
От Ian Axelrod
Тема Re: A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.
Дата
Msg-id CA+B3G4TFzHmRt2odVjmGT7=3jeUzbcQLT8LcpZ6A5fAucSgPfg@mail.gmail.com
обсуждение исходный текст
Ответ на 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>)
Список 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 по дате отправления: