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? Thanks -- Angular momentum makes the world go 'round.
