| From: | wenhui qiu <qiuwenhuifx(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | optimize the value of vacthresh and anlthresh |
| Date: | 2024-11-04 08:30:36 |
| Message-ID: | CAGjGUA+y4XDCBk31MiV=6p8U5V-K+TFFBmRnkM3kJZp-AXJyRw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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),I
refer to the sql server implementation method, submit a patch, please see
the attachment, hope to get the help of expert hackers
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-optimize-the-value-of-vacthresh-and-anlthresh.patch | application/octet-stream | 1.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bertrand Drouvot | 2024-11-04 08:48:56 | Re: Clear padding in PgStat_HashKey keys |
| Previous Message | Jelte Fennema-Nio | 2024-11-04 08:27:43 | Re: Clear padding in PgStat_HashKey keys |