On Wed, Jul 27, 2016 at 6:22 PM, thomas veymont <thomas.veym...@gmail.com> wrote: > as far as I remember these settings were for faster bulk loading. > > in 9.5 we set: > max_wal_size = 6GB # > https://www.postgresql.org/docs/9.5/static/release-9-5.html, max_wal_size = > (3 * checkpoint_segments) * 16MB > #min_wal_size = 80MB > > though I tried max_wal_size = 3GB (default is 1GB) and did not notice any > improvment.
And do you see changes if you increase min_wal_size? This will increase the number of WAL segments recycled instead of removed at each checkpoint. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
