Postgres Pro
Downloads
Home   >   mailing lists

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

From Frédéric Yhuel
Subject Re: optimize the value of vacthresh and anlthresh
Date
Msg-id 26c34b58-cde7-4e3c-a3a8-818bab157731@dalibo.com
Whole thread Raw
Responses Re: optimize the value of vacthresh and anlthresh
List pgsql-hackers
Tree view 

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

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Eager aggregation, take 3
Next
From: Ronan Dunklau
Date:
Subject: Re: Converting contrib SQL functions to new style