| From: | wenhui qiu <qiuwenhuifx(at)gmail(dot)com> |
|---|---|
| To: | Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: optimize the value of vacthresh and anlthresh |
| Date: | 2024-11-06 10:55:19 |
| Message-ID: | CAGjGUALqSDkWCjCJfMphTUSc9P7LMBfC4B7k1vs2JpJwfLyYpQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)yhuel(at)dalibo(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2024-11-06 11:23:19 | Re: Commit Timestamp and LSN Inversion issue |
| Previous Message | Peter Eisentraut | 2024-11-06 10:50:34 | Re: further #include cleanup (IWYU) |