Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres 9.5 deprecated checkpoint_segments, now uses min_wal_size, max_wal_size instead #21

Open
xpe opened this issue Oct 16, 2016 · 1 comment

Comments

@xpe
Copy link

xpe commented Oct 16, 2016

I just ran pgtune. It suggested an adjustment to checkpoint_segments. However, according to https://www.postgresql.org/docs/9.6/static/release-9-5.html, checkpoint_segments is no longer present:

Replace configuration parameter checkpoint_segments with min_wal_size and max_wal_size (Heikki Linnakangas)

If you previously adjusted checkpoint_segments, the following formula will give you an approximately equivalent setting:

max_wal_size = (3 * checkpoint_segments) * 16MB

Note that the default setting for max_wal_size is much higher than the default checkpoint_segments used to be, so adjusting it might no longer be necessary.

@andreif
Copy link

andreif commented Apr 3, 2017

It will be fixed via #18.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants