This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 63%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Hi,
I using the Azure Postgres and need changes settings to Tuning the Postgres, but not access a some importante properties.
Changing this properties checkpoint_completion_target, effective_cache_size, maintenance_work_mem, max_parallel_workers_per_gather, max_wal_size, min_wal_size, shared_buffers, wal_buffers, work_mem" it would make a big difference int the performace.
Someone with same problem or can help?
Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 57.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Hi @AnuragSharma-MSFT .
At my workplace we are looking at updating the shared_buffers property right now and came across this post which mentioned an update to make it possible to do so until the end of last year.
After reviewing the portal server parameters tab, I notice that "shared_buffers" is still not an available option, is there a new ETA for this change to happen?
Thanks,
Ricardo
Hi @AnuragSharma-MSFT ,
Thank's for your reply!
I try change this parameters, but this in red on print screen not list in the portal, and the postgres user is no permission for run alter command.
In blue the parameters that I managed to change.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Marcia Rodrigues , sorry for the trouble you are facing. I have reached out to product team on the same set of parameters highlighted in red and asked them to look into this. I will keep you updated as soon as possible.
Hi @Marcia Rodrigues , we have received the updates from product team. So currently Azure Database for PostgreSQL server does not support setting up these parameters, and the service automatically configures them based on server size.
There is a feature change going on to make these parameters available for the users but that could take end of year to reflect. No fixed ETA although. I will be following up and will update this thread once those changes are live.
Apologies for the trouble you faced on the same. Please let us know if there is anything else you would want to know.
----------
If the above answer helped you, please select "Accept Answer" which would help others in community facing similar issue.
Hi @AnuragSharma-MSFT,
Ok, Thank's for investigating.
One more question! =)
As long as we don't have this function, would it be possible to request the change by the Azure team?
PS: Following the values mentioned in the print screen, if possible fields in blue and red.
Hi @AnuragSharma-MSFT,
I review the price tier and a new question appear.
The Storage defini the IOPS, this value impact directily in the CPU em memory consumption, right?
If increase the storage, the other resources receduces the consumption?
Thanks!
Hi @Marcia Rodrigues , to reply to your first query I have again reached out to product team to check if those fields highlighted in red and blue can be updated on demand and I am awaiting their reply on this. I will update you as soon as I get that information. Sorry for the delay.
I am going through the other query related to increase in storage and will get back to you shortly.
Hi @Marcia Rodrigues , thanks for your patience. As per the latest updates from product team, currently modifying these highlighted parameters are not supported yet. However as mentioned, they are working on these parameters and hopefully we can have them configurable in near future. In addition to this, you can log a request for this feature in below link:
https://feedback.azure.com/forums/597976-azure-database-for-postgresql
Related to other query if you change the pricing tiers and increase the storage accordingly, it would not help much for CPU memory consumption. If you are maxing out CPU, you might want to scale up your server by increasing the number of vCores as it can handle huge workloads. Please refer to below links for more details on performance of resources.
https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-database-for-postgresql-performance-quick-tips/ba-p/369125
https://learn.microsoft.com/en-us/azure/postgresql/concepts-query-store
Thanks a lot @AnuragSharma-MSFT!
@Marcia Rodrigues Thanks for reaching out to us. You can update the mentioned parameters as below:
1) Go to Azure Portal and go to 'Azure Database for PostgreSQL server' resource created. Select 'Server Parameters' under 'Settings' from left Menu:
2) Select the appropriate properties you would like to change as below and click on 'Save' button:
3) You can change as many parameters as needed. Please let me know if this helps you out.
----------
If the above answer helped you, please select "Accept Answer" which would help others in community facing similar issue.