Re: optimize the value of vacthresh and anlthresh - Mailing list pgsql-hackers

From wenhui qiu
Subject Re: optimize the value of vacthresh and anlthresh
Date
Msg-id CAGjGUALqSDkWCjCJfMphTUSc9P7LMBfC4B7k1vs2JpJwfLyYpQ@mail.gmail.com
Whole thread Raw
In response to Re: optimize the value of vacthresh and anlthresh  (Frédéric Yhuel <frederic.yhuel@dalibo.com>)
List pgsql-hackers
Hi Frédéric
    many thanks for your email。
I'll go and see.

On Wed, 6 Nov 2024 at 17:47, Frédéric Yhuel <frederic.yhuel@dalibo.com> wrote:


On 11/4/24 09:30, wenhui qiu wrote:
> Hi hackers
>      A few days ago, I was looking at the sql server documentation and
> found that sql server has optimized the algorithm related to updating
> statistics in the 2016 ,version,I think we can also learn from the
> implementation method of sql server to optimize the problem of automatic
> vacuum triggered by large tables,The Document
> link(https://learn.microsoft.com/en-us/sql/relational-databases/statistics/statistics?view=sql-server-ver16 <https://learn.microsoft.com/en-us/sql/relational-databases/statistics/statistics?view=sql-server-ver16>),I refer to the sql server implementation method, submit a patch, please see the attachment, hope to get the help of expert hackers

similar idea here :
https://www.postgresql.org/message-id/6a2ac9b7-6535-4bb1-8274-0647f7c31c82%40dalibo.com

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: further #include cleanup (IWYU)
Next
From: Amit Kapila
Date:
Subject: Re: Commit Timestamp and LSN Inversion issue