question

MarciaRodrigues-7525 avatar image
0 Votes"
MarciaRodrigues-7525 asked RicardoCamacho-0757 commented

Azure PostgreSql Tuning

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.

azure-database-postgresql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
MarciaRodrigues-7525 avatar image
0 Votes"
MarciaRodrigues-7525 answered MarciaRodrigues-7525 commented

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.

16909-pgparams.png



In blue the parameters that I managed to change.


pgparams.png (19.0 KiB)
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MarciaRodrigues-7525, 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.

0 Votes 0 ·

Hi @MarciaRodrigues-7525, 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.

0 Votes 0 ·

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.

0 Votes 0 ·

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!

18062-pgparams2.png


0 Votes 0 ·
pgparams2.png (38.7 KiB)
Show more comments
AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

@MarciaRodrigues-7525 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:
16849-image.png


2) Select the appropriate properties you would like to change as below and click on 'Save' button:

16818-image.png

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.







image.png (104.7 KiB)
image.png (157.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.