question

SajithShetty-4024 avatar image
0 Votes"
SajithShetty-4024 asked AnuragSharma-MSFT commented

configuration parameter does not exist - azure postgres single server

We are using Azure postgres DB single server. I wanted to modify parameter - checkpoint_timeout to its desired value as per our DB load. However it does not show up in server parameter setting menu , nor in command line interface. Is it limitation of single server, that we cannot modify some parameters at all.?

Thanks in advance.!

azure-database-postgresql
· 6
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 @SajithShetty-4024, welcome to Microsoft Q&A forum.

Yes rightly said by you, checkpoint_timeout server parameter is not available with Single Server, however I have reached out to Product group to check more on this. I will get back to this thread at the earliest I receive the reply back.

1 Vote 1 ·

Hi @SajithShetty-4024, thanks for your patience. As per the product group due to difference in underlying infrastructure we don’t offer checkpoint_timeout parameter as user configurable in single server. But at the same time we would like to understand if there is any use case where you want to set this parameter value. Like do you want to reduce number of checkpoints? Is the checkpoint causing significant fluctuation in the workload throughput? Increasing checkpoint duration may have adverse impact on application availability in case of failures/restarts.

0 Votes 0 ·

Hi @AnuragSharma-MSFT , Thanks for your response.

We have high average data manipulation for one of our customers every 5 minutes. We need to set max_wal_size to around 20 GB
and checkpoint_timeout to at least 20 minutes. All these are in the testing phase.


As per the log analysis, a high volume of data is being processed continuously in 5 minutes now; there are very few seconds or mostly none left between every checkpoint and causing high I/O overhead during the checkpoint process.

We are aware of the fact that checkpoint_timeout implies recovery time, which is fine considering the performance impact.

Note that we are also planning to upgrade our single server to a FLEX server, however, there are compatibility issues to be resolved on the application side. Meanwhile, can you confirm if checkpoint_timeout can be controlled in the flex server?

0 Votes 0 ·
Show more comments

0 Answers