Settings for fast restores

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Settings for fast restores
Date: 2018-08-01 06:03:40
Message-ID: 158db2d8-6dc2-95c7-6247-1d405366e2ff@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Lembark 2018-08-01 07:37:18 Re: Question on postgresql.conf
Previous Message Andres Freund 2018-08-01 04:00:57 Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function