We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
我在postgresql引擎下创建集群测试后发现在cpu、mem、disk扩容下相应的参数没有受到影响。 1.查看配置文件得知,cpu扩容后max_parallel_maintenance_workers,mem扩容后effective_cache_size,disk扩容后max_wal_size都会受到影响。(我的pg版本为12,这里截图为14的,但是它们这些参数相同) 2.分析配置文件后可以得知,当集群由cpu=5,mem=1G,disk=3G扩容到cpu=5.1,mem=6G,disk=5G后这三个值都会受到影响,于是我手动创建这两个状态下的集群,并查询相关参数进行验证。 发现这些值确有改变: 3.我使用测试程序创建集群进行扩容,发现扩容前后参数没有变化 4.为了排除程序的问题,我又手动查询集群的配置和相关参数,发现确实没有变化
The text was updated successfully, but these errors were encountered:
JashBook
Successfully merging a pull request may close this issue.
我在postgresql引擎下创建集群测试后发现在cpu、mem、disk扩容下相应的参数没有受到影响。
![image](https://private-user-images.githubusercontent.com/78309270/324303059-9a0aa6c0-7eb8-4e0f-8c3b-a7d0f2242e1f.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDMwNTktOWEwYWE2YzAtN2ViOC00ZTBmLThjM2ItYTdkMGYyMjQyZTFmLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTAyZjdiMmI4MGY0MWViZWYyMjA2MTE3ZGI3Zjk2MWYzNDU1ODQ4NzNjMzIyMTc5MzIzNDEzMGI5YjYzOGJiOTgmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.oxYO5eRHv5WM9Fy5Lit54Mfj6QAnL81Z71dcE2tweBw)
![image](https://private-user-images.githubusercontent.com/78309270/324302458-b1a5a43d-d485-471d-afb5-65283dce84ee.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDI0NTgtYjFhNWE0M2QtZDQ4NS00NzFkLWFmYjUtNjUyODNkY2U4NGVlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWI0MWI0NjYzOTMzNTBiZTBkOTlhNjg5Y2M4MDMxYTQ5NGJhZWU3YzVmMGJhMWZiZGUzYjY0MzM4NjliNzVjZDYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.UBYEpe4npdRLcF0FfkF8ILmX6om7xzBtG7gKcvdlWfY)
![image](https://private-user-images.githubusercontent.com/78309270/324303189-452c722d-9743-443b-96f1-708b18cc0160.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDMxODktNDUyYzcyMmQtOTc0My00NDNiLTk2ZjEtNzA4YjE4Y2MwMTYwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTU4NTY2MGZmZDE2ZWY4NWNmZmJhNjQzNzQ5ODIyZGI0NmZhOTJmNzYxOWYyZmE5NWIyYTQ1ZWNkMDlhODU0YzgmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.Z8Rm99B-_VIMOJ1txb8Hddp1TxvCLWzfY92pP2-M98M)
![image](https://private-user-images.githubusercontent.com/78309270/324303701-1c1ceb54-8b27-4d17-86db-fefbfb93893c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDM3MDEtMWMxY2ViNTQtOGIyNy00ZDE3LTg2ZGItZmVmYmZiOTM4OTNjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWQxOTZkNGEwM2E4NjhlNGJhZjIwOGZmNzczYTdmM2RhZDM4YTA3NTczZWYzNjY2ZWJiYTc5ODQxOTYwODZjYzImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.QRBHyDiz9rvOPTn08e0QWW3R-gK0gbeBzpm_JAEtC00)
![image](https://private-user-images.githubusercontent.com/78309270/324310259-2e146f84-ddec-43d2-ad54-200292d3a40e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMTAyNTktMmUxNDZmODQtZGRlYy00M2QyLWFkNTQtMjAwMjkyZDNhNDBlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTBlZmM5MTRkOGZmNGQ1YTFjNTYwNzk4MTQxODBlNmUxNGM0YzExZDg2YmZjMTM5YWYwNjkzYTUwNWQzYjBmMDMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.yCWj3FWNEivIgGoyJxNxuhJfeCln3WD5CGDBykC9fCA)
![image](https://private-user-images.githubusercontent.com/78309270/324309865-a99dc35d-d0a1-49a4-bd8b-5e1eb837c1f4.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDk4NjUtYTk5ZGMzNWQtZDBhMS00OWE0LWJkOGItNWUxZWI4MzdjMWY0LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWU0NjJjZTQ2YjE5Y2I1Y2VlMzAxM2M4OWU2ZDY5MTJmZWNiYjM3NzI1OWQ5M2Y1Yzk3YTQyZDNlYWYwNTZiMTUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.IVQrMA25eHjZUC2NpCWUsi5oAotwtaRNfqiYMF46lyU)
![image](https://private-user-images.githubusercontent.com/78309270/324309759-1f8cba7b-99e8-4d08-a015-494eb0100e56.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDk3NTktMWY4Y2JhN2ItOTllOC00ZDA4LWEwMTUtNDk0ZWIwMTAwZTU2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWY4YjY1ODAzZTUwYTg1ZWYzZWVmMDNkZWIzNWU0YzQyOGM0MzUxZDk0YjQ2YzAyMGY4OWVlODg2Y2FiNWE0YTEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.610wEmtttLXWbURaGykVxvcYzBUDOZrVR6C-MubsH8U)
![image](https://private-user-images.githubusercontent.com/78309270/324309617-6986bbed-b80f-4121-9369-64eaf941dce1.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDk2MTctNjk4NmJiZWQtYjgwZi00MTIxLTkzNjktNjRlYWY5NDFkY2UxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTVkMjIyMDc0NjM0MDU1ZGMyZDU2MmE3YWM4NGNjMzA4MmM4YmIwZmE5YmJlZWI3YmE5ZTdiY2FjMGFhMzgwMDYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.VBTfNh7Q23kh1T0kvx3COaw3mn4imUXDpDsYiLtqmmk)
![image](https://private-user-images.githubusercontent.com/78309270/324303580-8beb58ef-3151-415d-8052-b82702e3b9c6.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDM1ODAtOGJlYjU4ZWYtMzE1MS00MTVkLTgwNTItYjgyNzAyZTNiOWM2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTJkNDQ0OWY1MzZkZTBjYzM1Mzk5ZjA4NTE1YjdiNDYyMzMwOTM3ODMxOTBkNWZhNWMxOTBiZTBjMWFjMWY5NmUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.xQ5Wow07n_x0a1sVStYG4ex54MAAv8VXc0UvOTZ4H9A)
![image](https://private-user-images.githubusercontent.com/78309270/324304308-68b827ab-d256-4365-99ee-27c6ae45964d.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDQzMDgtNjhiODI3YWItZDI1Ni00MzY1LTk5ZWUtMjdjNmFlNDU5NjRkLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTgzMDY1YWQyMDY0Y2E5ZGEwOGI1YjViNDM3NDBjYmIxZWY5YzYwYjYzNWViMTkzMTM3OGY2OGVmODRiM2ViZWMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.t1e2rTsR2T7GeyXMiCqOrOsZMKRPCTgDlF9uCDNEaQg)
![image](https://private-user-images.githubusercontent.com/78309270/324310412-a1cd84ae-d24c-4472-9cfd-e64f424b6d50.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMTA0MTItYTFjZDg0YWUtZDI0Yy00NDcyLTljZmQtZTY0ZjQyNGI2ZDUwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTdmODk5MDliMTllNzNiOTUyMWFjYzRmZWM3ZTNlMWZjM2Y3Y2NjNjgwNWIyNGE2NmI4MTQyODZjZDZkZDc5MTImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.nA0Q0NxdXIX-SWulaGmwLV_JW0tGfnH902IENmimSTQ)
![img_v3_02a3_bf1b7c7d-3085-4bc0-9d67-b771fea6575g](https://private-user-images.githubusercontent.com/78309270/324304358-982b9d1e-f923-4360-8c4c-4414ca34681c.jpg?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDQzNTgtOTgyYjlkMWUtZjkyMy00MzYwLThjNGMtNDQxNGNhMzQ2ODFjLmpwZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWRiZTAzNGQ0YjRjYjM0YzU4Y2FhN2NjZDMwOTNhNjE0ZmEwOTQwODIwYzJmYzZkMWRhZDA2NWI3ZjU3MDBlMWQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.c3Lllf2zdnTAveImoKc4ZfT6OQQExjAG-uqxEuUNOg8)
![img_v3_02a3_66177294-f4b2-41b0-9be6-fe78b6bd717g](https://private-user-images.githubusercontent.com/78309270/324304365-1696cdf0-77a0-4037-b48c-ce4649e0b083.jpg?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDQzNjUtMTY5NmNkZjAtNzdhMC00MDM3LWI0OGMtY2U0NjQ5ZTBiMDgzLmpwZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTUxYTc1OTFjMmI5NGRlZmZjMTljMzhjNDMwMjAwODY3Y2MzMmRjZDM4ZTQ1NTk2ZjIzNzExZWY2NGUwZjhhNDAmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.MDfp_dIF7CQHgnZqNr6Wa3W_Or_pCZUDBuN2MovJ3Z4)
![img_v3_02a3_303b418f-ba36-429f-849f-130ed3618a2g](https://private-user-images.githubusercontent.com/78309270/324304397-0fb44a2d-8aa0-40d5-9044-c1e8e5d286e0.jpg?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDQzOTctMGZiNDRhMmQtOGFhMC00MGQ1LTkwNDQtYzFlOGU1ZDI4NmUwLmpwZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWI3ZmNkM2FjMjA2YTUxNzJjMGZkYTY5NGJkNWU5ODkwOWI4YzJjYzdkYjIwY2E5YjU0YmJkYjZjMzNiZGVmZTAmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.adLNMXhvKDsr0B2MiPORX4G3aDsEaz7j6ofmZ4Ctq40)
![image](https://private-user-images.githubusercontent.com/78309270/324305195-3a2adf59-2fa9-4417-9742-e0d1f27d80da.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDUxOTUtM2EyYWRmNTktMmZhOS00NDE3LTk3NDItZTBkMWYyN2Q4MGRhLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTBmNGIxZDU2NzM4ODg2ZTk1NTM2ZGRiNTQ1ZWVkOTRkMjAyZGU3YzI4OTdhMzQxNGY1Mzc0MTlmZTFkMzU5M2EmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.qCoPWdVssH2h9pi4_bgDGnwQNwibOe6IO-IrbNXEreA)
![image](https://private-user-images.githubusercontent.com/78309270/324308654-6f2ee7b2-2634-4733-9dbb-6c7458c9e0ca.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkyNjMxODAsIm5iZiI6MTczOTI2Mjg4MCwicGF0aCI6Ii83ODMwOTI3MC8zMjQzMDg2NTQtNmYyZWU3YjItMjYzNC00NzMzLTlkYmItNmM3NDU4YzllMGNhLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTElMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjExVDA4MzQ0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWRiYzI2OWQxMTNhOGNiZjI2MDNmNGZkNTBmZmZkYzQ0MGJiNmMxYTk2NDU1MTVkMWMwZGUwZDNlMjc4MmMzNWImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.JE1rv4sW7LNvVxeuxonx44yFpnURwFOpj_joj3zQPM4)
1.查看配置文件得知,cpu扩容后max_parallel_maintenance_workers,mem扩容后effective_cache_size,disk扩容后max_wal_size都会受到影响。(我的pg版本为12,这里截图为14的,但是它们这些参数相同)
2.分析配置文件后可以得知,当集群由cpu=5,mem=1G,disk=3G扩容到cpu=5.1,mem=6G,disk=5G后这三个值都会受到影响,于是我手动创建这两个状态下的集群,并查询相关参数进行验证。
发现这些值确有改变:
3.我使用测试程序创建集群进行扩容,发现扩容前后参数没有变化
4.为了排除程序的问题,我又手动查询集群的配置和相关参数,发现确实没有变化
The text was updated successfully, but these errors were encountered: