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.