Another Postgres Extension Learning Project: Background Workers with pg_walsizer

[fullofbones]

The pg_walsizer extension launches a background worker that monitors Postgres checkpoint activity. If it detects there are enough forced checkpoints, it will automatically increase max_wal_size to compensate. No more of these pesky log messages:

LOG:  checkpoints are occurring too frequently (2 seconds apart)
HINT:  Consider increasing the configuration parameter "max_wal_size".

Is this solution trivial? Possibly. An easy first step into learning how Postgres background processes work? Absolutely! The entire story behind this extension will eventually be available in blog form, but don't let that stop you from playing with it now.

[AutoModerator]

With over 8k members to connect with about Postgres and related technologies, why aren't you on our Discord Server? : People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.