Re: Auto Vacuum optimisation

HI Japin Li
Thank you for you reply, Do you think that removing the log2 algorithm
because it will be more frequent,I think sql server chose sqrt algorithm
after their long-term verification, I think we need to retain sqrt
algorithm,The relevant documents are here(
https://learn.microsoft.com/en-us/sql/relational-databases/statistics/statistics?view=sql-server-ver16),I
will provide a new patch later with your reply

Thanks

Japin Li <japinli(at)hotmail(dot)com> 于2024年11月26日周二 21:26写道：

>
> On Mon, 18 Nov 2024 at 18:20, wenhui qiu <qiuwenhuifx(at)gmail(dot)com> 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
>