Settings for fast restores - Mailing list pgsql-general

From Ron
Subject Settings for fast restores
Date
Msg-id 158db2d8-6dc2-95c7-6247-1d405366e2ff@gmail.com
Whole thread Raw
Responses Re: Settings for fast restores
List pgsql-general
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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to prevent "no wait lock" after a connection drop
Next
From: Steven Lembark
Date:
Subject: Re: Question on postgresql.conf