From: Japin Li <japinli@hotmail.com>
To: wenhui qiu <qiuwenhuifx@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>,  =?utf-8?B?RnLDqWTDqXJp?=
 =?utf-8?B?Yw==?= Yhuel
 <frederic.yhuel@dalibo.com>
Subject: Re: Auto Vacuum optimisation
In-Reply-To: <CAGjGUAKtyAdOjOZ3NuXNG=URp9iXnGpk+vo01GenxuaWbD5maQ@mail.gmail.com>
	(wenhui qiu's message of "Mon, 18 Nov 2024 18:20:28 +0800")
References: <CAGjGUAKBLZAeA21ORp+s1S0uU7wAv0Mco2+Wh9uDAVDe3t+_LQ@mail.gmail.com>
	<CAGjGUAKtyAdOjOZ3NuXNG=URp9iXnGpk+vo01GenxuaWbD5maQ@mail.gmail.com>
Date: Tue, 26 Nov 2024 21:25:56 +0800
Message-ID:
 <ME0P300MB0445EBD1D3DAE6066C639813B62F2@ME0P300MB0445.AUSP300.PROD.OUTLOOK.COM>
Content-Type: text/plain
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: ME0P300MB0445:EE_|ME0P300MB0584:EE_
X-MS-Office365-Filtering-Correlation-Id: 4669b7cd-46a8-4166-55f9-08dd0e1ddf19
X-Microsoft-Antispam:
	BCL:0;ARA:14566002|15080799006|7092599003|5072599009|8060799006|461199028|19110799003|10035399004|3412199025|4302099013|440099028|1602099012;
X-Microsoft-Antispam-Message-Info:
	=?us-ascii?Q?yNRJggbgKyyZuiwIrVSEUIQ7KVtcYzECOzadB4ierMv1UbLemOUPseSbEus3?=
 =?us-ascii?Q?mIPd+Bm4l2bLdSnF0leCFwjjerHE+RmkT4d4u4iDR2BRuRrZhQVWJhmakJC+?=
 =?us-ascii?Q?D66FLrWbO+cElamyTI9Bu8jlWnXM6a2KbcZGWOgurWjBq0u4/yadZzXDBr7V?=
 =?us-ascii?Q?ZHKj5eY2IP7xzkZLflkS7Yb+XF33j51LV2JQnqZHPpmQXkHvNsuaMkc7+1d5?=
 =?us-ascii?Q?87J2PZTHUQW2Bz+U176EbQGsjcsDt79gwENPdm7jJczy+Jgi9hdC/D5ue3PR?=
 =?us-ascii?Q?TO/spU131Ccf7i1CSLLIldQoSDUG194jDc0R7jGge6AGRn6I8sVlYT2Agptt?=
 =?us-ascii?Q?lMmRNWTwxomF5lTm6XCHgSN6lBUhHK0J2OiHJcaiInPNO6mP0cN8u2JlRI1A?=
 =?us-ascii?Q?f9Q1KbAONo1+AbNcQLVZYqNxa16kHmiZsvOp2PDjSey5bqtbio/Kr35KMYgF?=
 =?us-ascii?Q?eJYXISXSBkCNpPBIlJiHl8nr9HREFO7dd2YwQdUZpTkGiWPwcJz68BHT0A/k?=
 =?us-ascii?Q?FgCJXULP6km+mqf/cQuO0U4lTJYEmoAWYkCMs/lMF0/o+3T5PK5zMUbR8Acn?=
 =?us-ascii?Q?u8gJ0GUlrqR/IrZZyb0hYBwGKq8PY30R32drMdgn13RDMDEfmdC1w4IzEwiL?=
 =?us-ascii?Q?e6Ur6EmsFNBtsNkyIn93SfYyxMglRYBpHeD/w+OqdaQaS/Xgez0Lopw9w8mR?=
 =?us-ascii?Q?t0JfXgGBrs5pJN5f6tWsIhZWckAQNrC47k9Zy/VsdIz3F8GwS7sW1Yc2Cc4e?=
 =?us-ascii?Q?h9lfssxQDuih+irDMjzakEqyXEtMVMw+2s4jXH/Vea/WAldJGnGkNlIF8A/o?=
 =?us-ascii?Q?aClx3CpjGNISwEBI8+9bLos9sCh99jZSqf+lXkG6Q/MxxbLzylGjuK5dtX2F?=
 =?us-ascii?Q?aRxC/XsYbOJFPw/3tkA6LUJXLGgj0X5BdtEnIb2YZhJojsG6ji99buEFoaiF?=
 =?us-ascii?Q?IB51PLHsA2ovt0w8M7LkzG+Vzw0DFCmHiuoDSNAUnTTkaxv3IYxqP/yHiVSv?=
 =?us-ascii?Q?MgQdCkk2MAr+0ItHkqqYIhx0nkt8/mXXcNvxQlpeEzGhrzyTbB2rfGE/svKs?=
 =?us-ascii?Q?O4yePXfN/XBCPTx3lD31GjvivtxwU/IVcMaRl5MTtyXVr2B4AQXHOBzd++vI?=
 =?us-ascii?Q?MSWt8HyjE2ZDSnQOHkVN7BfZDzwkMPgzUQ=3D=3D?=
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?us-ascii?Q?jWVN/1RYP5vF2XtIw2RxZNmCWACjGMp/FT6j435lzw7JPkiXV7V2RHyrhZuY?=
 =?us-ascii?Q?SeFHQga7+ahl6jRr4g883SzKNeH7wQvsMFHKhx55SOLrx4PZMm4DFLOhHIGd?=
 =?us-ascii?Q?x1ntxeqxON0wyTdMO16UyNz1OdyGGFRcJPsscDINyDgODpHQEuamid8qUEyB?=
 =?us-ascii?Q?qRsLG6xAb91ZzmhHTJFhdv9H6BwCl61yNGvzfUqPNnmZ28q/ASzfhD81GGUq?=
 =?us-ascii?Q?nikIhJDS2OVcNk49LPlB+/kZL2CzOYSl1PagLOqDMIrFWR6Hx98MjXMw0BvH?=
 =?us-ascii?Q?H4ptGk6gy6CX+tbMJRLRZVr8vN+WwnMLK0xoywhJ9G0xQQ2mgHvYyPXLChef?=
 =?us-ascii?Q?DfhAWylXREJgRYmHPSgnIfx9K2gMvSvMRM/B5RWQzJgK8PuYt+SEa+owmhbK?=
 =?us-ascii?Q?Q+ZxNlSliKEXHrwaHaeLJMMaHT9R3OzFmIOAn1YYSNSQKnxRtFFpBg2mh0kl?=
 =?us-ascii?Q?xXBcnkhuYyz3XmS8DudmxkWYOfX5iTvsodOPpyE6RDMP20ilMe3Wi7Vnddan?=
 =?us-ascii?Q?Je26ybOoVkmFE7YglJtkcLR/CMnaJzms6P10gR8EzlJAQElNljZpZ6dZIOWh?=
 =?us-ascii?Q?5ziEIWc9Qjc8rOYSJlObx3c0NpDAUAraf8GJ1taC/We5IvqzNsJk1iLC7PgL?=
 =?us-ascii?Q?P/4WDoHdq+ZBhvoPGM46DDOlmixUnrnY1VwLEWEjeLKOvKkDr2W3ay924x7O?=
 =?us-ascii?Q?/qROawEKGmS8I6p/Tee/X8keFhWl62+3G+3DYaWlULIdVD17UwRkQ+B95Ooo?=
 =?us-ascii?Q?iCOi0ashvLv+BxDHzMJkuoOurC6+fOnTlZGtUNx0WHf31qYirSCAxfog0Yzn?=
 =?us-ascii?Q?AgxgedyJC4wV4EqqyE3VIHzwrOgY+fe/G+I165DQrz9O3xDp5EwBaV7WIf4m?=
 =?us-ascii?Q?NYiwZBNW2dFNdztJyRrNs9wGuk3jWV14xgLXhq3FGL4q4hv4WkTpHcmXTkaA?=
 =?us-ascii?Q?3hUWPfXefSQ9/uRFJhLHk6uIKo8CjFhtKZJaF7WO81pP/gtSurZ0p/949Jgy?=
 =?us-ascii?Q?8lQVTvBkhmdTJnpqCy5qyMeJIZB7FHWdsi0LTS1FtFgGseQm6KD2+0OarbpT?=
 =?us-ascii?Q?wtP4iABwDfdZTVSexE+nuFymFKB1gI0eQ+XYO+Qlc+ByIuOv0gc9HrDCa47L?=
 =?us-ascii?Q?ef9h8IY9NRewGB/QKqEMeTYfOGpdBkEZjGEkbkctjOvbqOWc2ggloHCoQjgN?=
 =?us-ascii?Q?9CutPYna+A9+0oNLpPMg/Bhk3PBhbEeGiGYZBgD09zT/3iIrDX6JcnmsoZM?=
 =?us-ascii?Q?=3D?=
X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-448bf.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 4669b7cd-46a8-4166-55f9-08dd0e1ddf19
X-MS-Exchange-CrossTenant-AuthSource: ME0P300MB0445.AUSP300.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 26 Nov 2024 13:26:01.8562
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg:
	00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: ME0P300MB0584
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/ME0P300MB0445EBD1D3DAE6066C639813B62F2%40ME0P300MB0445.AUSP300.PROD.OUTLOOK.COM>
Precedence: bulk


On Mon, 18 Nov 2024 at 18:20, wenhui qiu <qiuwenhuifx@gmail.com> wrote:
> HI hackers
>    These are algorithmic mathematical graphs,By default, vacuum will not be triggered frequently.Looking at the images
> the algorithms for pow and sqrt are close, do we want to cancel one of the algorithms? 
>
> 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-4bb1-8274-0647f7c31c82%40dalibo.com),I referring to the
>  discussion in there, I implemented a parameter selection triggering the calculation of AUTO VACUUM,This is my first
>  patch for the community.Hoping for support from the experts

I think this is helpful.

One of our customers had large tables that were frequently updated, and their
global configuration did not permit timely VACUUM operations on those tables.
As a result, they had to adjust the vacuum settings for those specific tables,
which unintentionally increased their maintenance burden.

However, I'm not sure we need so many autovacuum algorithms here since it makes
the choice harder (maybe).

-- 
Regrads,
Japin Li