public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Rowley <[email protected]>
To: Peter Geoghegan <[email protected]>
Cc: Nathan Bossart <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: Jeremy Schneider <[email protected]>
Cc: Sami Imseih <[email protected]>
Cc: [email protected]
Subject: Re: another autovacuum scheduling thread
Date: Sat, 25 Oct 2025 11:25:02 +1300
Message-ID: <CAApHDvq5x+Su54QFhQDTkz+oUG2XbPGugOgp2YbhrTXTbbrGJQ@mail.gmail.com> (raw)
In-Reply-To: <CAH2-WzkF9=LAPoVCGKd-q9AOJtJFzGt8vJ9Bdq=3KrAsrhm68w@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CAApHDvq76BBseUh2cG0=m=8r-j6HF_jrQt16Eszgsxp3bciGQw@mail.gmail.com>
<aOffPCBoQLG5dGd8@nathan>
<aOlC4aDoQcgW8ZpC@nathan>
<CA+TgmoYC4ShRp8vcyrBjkefSBdFfY1fnUgCvjocN-iq55G-7bA@mail.gmail.com>
<CAApHDvqrd=SHVUytdRj55OWnLH98Rvtzqam5zq2f4XKRZa7t9Q@mail.gmail.com>
<aPea8dG8_lFwTsyo@nathan>
<CAApHDvocam8_cxqO=LiSifgp0B3rs1=VWRVQiwAwz_DvOMgfVw@mail.gmail.com>
<aPklC5V61VcTu7IP@nathan>
<aPkpSXHB66islP3h@nathan>
<CAApHDvqobtKMwJbhKB_c=3-TM=TgS3bcuvzcWMm3ee1c0mz9hw@mail.gmail.com>
<CAH2-WzkF9=LAPoVCGKd-q9AOJtJFzGt8vJ9Bdq=3KrAsrhm68w@mail.gmail.com>
On Sat, 25 Oct 2025 at 10:14, Peter Geoghegan <[email protected]> wrote:
>
> On Wed, Oct 22, 2025 at 3:35 PM David Rowley <[email protected]> wrote:
> > If we had the varying sleep time as I mentioned above, the
> > failsafe code could even be removed as the
> > "autovacuum_vacuum_cost_delay / <tables score>" calculation would
> > effectively zero the sleep time with any table > failsafe age.
>
> I'm not sure what you mean by "the failsafe could be removed".
> Importantly, the failsafe will abandon all further index vacuuming.
> That's why it's presented as something that you as a user are not
> supposed to rely on.
I didn't realise it did that too. I thought it just dropped the delay
to zero. In that case, I revoke the statement.
David
view thread (143+ 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], [email protected], [email protected], [email protected]
Subject: Re: another autovacuum scheduling thread
In-Reply-To: <CAApHDvq5x+Su54QFhQDTkz+oUG2XbPGugOgp2YbhrTXTbbrGJQ@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