Skip to content
New issue

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

[BUG] postgresql:The parameters are not affected after VerticalScaling and VolumeExpansion #463

Open
haowen159 opened this issue Apr 22, 2024 · 0 comments · Fixed by #834
Assignees

Comments

@haowen159
Copy link
Contributor

我在postgresql引擎下创建集群测试后发现在cpu、mem、disk扩容下相应的参数没有受到影响。
1.查看配置文件得知,cpu扩容后max_parallel_maintenance_workers,mem扩容后effective_cache_size,disk扩容后max_wal_size都会受到影响。(我的pg版本为12,这里截图为14的,但是它们这些参数相同)
image
image
image
2.分析配置文件后可以得知,当集群由cpu=5,mem=1G,disk=3G扩容到cpu=5.1,mem=6G,disk=5G后这三个值都会受到影响,于是我手动创建这两个状态下的集群,并查询相关参数进行验证。
image
image
发现这些值确有改变:
image
image
image
3.我使用测试程序创建集群进行扩容,发现扩容前后参数没有变化
image
image
image
img_v3_02a3_bf1b7c7d-3085-4bc0-9d67-b771fea6575g
img_v3_02a3_66177294-f4b2-41b0-9be6-fe78b6bd717g
img_v3_02a3_303b418f-ba36-429f-849f-130ed3618a2g
4.为了排除程序的问题,我又手动查询集群的配置和相关参数,发现确实没有变化
image
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants