Re: Settings for fast restores

2018-08-01 Thread Ron
On 08/01/2018 09:11 AM, Vick Khera wrote: On Wed, Aug 1, 2018 at 2:03 AM, Ron > wrote: Hi, http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html shared_buffers

Re: Settings for fast restores

2018-08-01 Thread Vick Khera
On Wed, Aug 1, 2018 at 2:03 AM, Ron 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 =

Settings for fast restores

2018-07-31 Thread Ron
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