Thread: Re: optimize the value of vacthresh and anlthresh
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>),Irefer to the sqlserver 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
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