Do you have an idea or suggestion based on your experience with Azure Database for PostgreSQL?

Making checkpoint_timeout longer to prevent freqent checkpointing

We are planning our PostgreSQL database to move to Azure Database for PostgreSQL.

Now, we are working on performance analysis and tuning (for database refactoring) prior to moving to Azure, and we have found that frequent checkpoints are generating heavy load.

So, we have checked the checkpoint parameters on Azure, and we afraid of that checkpoint_timeout (5min) is too short and it couldn't be changed by the user. It could generates frequent checkpoints.

I think 30~60min for the checkpoint_timeout parameter is very common [1], so I hope Azure would have that as the default value.

[1] Basics of Tuning Checkpoints
https://blog.2ndquadrant.com/basics-of-tuning-checkpoints/

13 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Satoshi Nagayasu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base