On Wed, Jul 27, 2016 at 6:22 PM, thomas veymont
<thomas.veymont@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