On Wed, Aug 1, 2018 at 2:03 AM, Ron <ronljohnso...@gmail.com> wrote: > Hi, > > http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html > > shared_buffers = 1/2 of what you'd usually set > maintenance_work_mem = 1GB-2GB > wal_level = minimal > full_page_writes = off > wal_buffers = 64MB > checkpoint_segments = 256 or higher > max_wal_senders = 0 > wal_keep_segments = 0 > > How many of these 4 year old setting recommendations are still valid for > 9.6? >
They all look still valid to me. I personally also set fsync=off since I can always start over if the machine crashes and corrupts the data.
