public inbox for [email protected]
help / color / mirror / Atom feedFrom: Japin Li <[email protected]>
To: wenhui qiu <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: Frédéric Yhuel <[email protected]>
Subject: Re: Auto Vacuum optimisation
Date: Tue, 26 Nov 2024 21:25:56 +0800
Message-ID: <ME0P300MB0445EBD1D3DAE6066C639813B62F2@ME0P300MB0445.AUSP300.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAGjGUAKtyAdOjOZ3NuXNG=URp9iXnGpk+vo01GenxuaWbD5maQ@mail.gmail.com>
References: <CAGjGUAKBLZAeA21ORp+s1S0uU7wAv0Mco2+Wh9uDAVDe3t+_LQ@mail.gmail.com>
<CAGjGUAKtyAdOjOZ3NuXNG=URp9iXnGpk+vo01GenxuaWbD5maQ@mail.gmail.com>
On Mon, 18 Nov 2024 at 18:20, wenhui qiu <[email protected]> wrote:
> HI hackers
> These are algorithmic mathematical graphs,By default, vacuum will not be triggered frequently.Looking at the images
> the algorithms for pow and sqrt are close, do we want to cancel one of the algorithms?
>
> log2
> image.png
>
> sqrt
> image.png
> pow
> image.png
>
Sorry for the late reply.
Did you forget to upload the pictures?
> There was an earlier discussion about auto vacuum optimisation(
> https://www.postgresql.org/message-id/6a2ac9b7-6535-4bb1-8274-0647f7c31c82%40dalibo.com),I referring to the
> discussion in there, I implemented a parameter selection triggering the calculation of AUTO VACUUM,This is my first
> patch for the community.Hoping for support from the experts
I think this is helpful.
One of our customers had large tables that were frequently updated, and their
global configuration did not permit timely VACUUM operations on those tables.
As a result, they had to adjust the vacuum settings for those specific tables,
which unintentionally increased their maintenance burden.
However, I'm not sure we need so many autovacuum algorithms here since it makes
the choice harder (maybe).
--
Regrads,
Japin Li
view thread (4+ messages)
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: Auto Vacuum optimisation
In-Reply-To: <ME0P300MB0445EBD1D3DAE6066C639813B62F2@ME0P300MB0445.AUSP300.PROD.OUTLOOK.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