Re: Auto Vacuum optimisation

2024-11-27 Thread wenhui qiu
Hi Japin > Worth a try. > However, I don't think we need to based on {vac,anl}_scale_factor when using > the sqrt algorithm. Here a new path, I removed the log2 algorithm and the debug2 log and the enumeration type is also kept consistent, based on {vac,anl}_scale_factor when using the sqrt algo

Re: Auto Vacuum optimisation

2024-11-27 Thread Japin Li
On Wed, 27 Nov 2024 at 15:51, wenhui qiu wrote: > HI Japin Li > Thank you for you reply, Do you think that removing the log2 algorithm > because it will be more frequent,I think sql > server chose sqrt algorithm after their long-term verification, I think we > need to retain sqrt algorithm,

Re: Auto Vacuum optimisation

2024-11-26 Thread Japin Li
thms? > > log2 > image.png > > sqrt > image.png > pow > image.png > Sorry for the late reply. Did you forget to upload the pictures? > There was an earlier discussion about auto vacuum optimisation( > > https://www.postgresql.org/message-id/6a2ac9b7-6535-4bb

Auto Vacuum optimisation

2024-11-18 Thread wenhui qiu
HI hackers and japin li There was an earlier discussion about auto vacuum optimisation( https://www.postgresql.org/message-id/6a2ac9b7-6535-4bb1-8274-0647f7c31c82%40dalibo.com),I referring to the discussion in there, I implemented a parameter selection triggering the calculation of AUTO