| From: | Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com> |
|---|---|
| To: | wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: optimize the value of vacthresh and anlthresh |
| Date: | 2024-11-06 09:47:53 |
| Message-ID: | 26c34b58-cde7-4e3c-a3a8-818bab157731@dalibo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ronan Dunklau | 2024-11-06 09:51:29 | Re: Converting contrib SQL functions to new style |
| Previous Message | Daniel Gustafsson | 2024-11-06 09:27:08 | Re: Changing the state of data checksums in a running cluster |