public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter Geoghegan <[email protected]>
To: Joshua Banton <[email protected]>
Cc: [email protected]
Subject: Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table
Date: Fri, 31 Jan 2025 17:45:48 -0500
Message-ID: <CAH2-WzmZEQn7jH3iYZvsgMJ93Z=POaGcgu4BSF73_vSgoZUKcg@mail.gmail.com> (raw)
In-Reply-To: <CAHkYM9bmCEq8J=tUMYr6HRNL03ddUX3JUPCKY6frngBCbuPrGw@mail.gmail.com>
References: <CAHkYM9bmCEq8J=tUMYr6HRNL03ddUX3JUPCKY6frngBCbuPrGw@mail.gmail.com>
On Fri, Jan 31, 2025 at 5:28 PM Joshua Banton <[email protected]> wrote:
> The issue mostly manifests near the end of the "scanning heap" phase of vacuuming of one of our largest tables, we'll call table1. RDS Performance Insights reports that selects on table1 start to wait on cpu, where previously it didn't even show up in the top 25 queries by wait. It doesn't always happen, but if there is a larger than usual number of selects on table1 it is more likely to happen.
Does this database also have many tables? As in thousands of tables?
I am reminded of this issue:
https://www.postgresql.org/message-id/flat/da3205c4-5b07-a65c-6c26-a293c6464fdb%40postgrespro.ru
I've heard of this happening when an aggressive VACUUM updates
relfrozenxid on a larger table.
--
Peter Geoghegan
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table
In-Reply-To: <CAH2-WzmZEQn7jH3iYZvsgMJ93Z=POaGcgu4BSF73_vSgoZUKcg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox