Re: increasing the default WAL segment size - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: increasing the default WAL segment size
Date
Msg-id 20160825132524.GA2830@momjian.us
Whole thread Raw
In response to Re: increasing the default WAL segment size  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: increasing the default WAL segment size
List pgsql-hackers
On Wed, Aug 24, 2016 at 10:40:06PM -0300, Claudio Freire wrote:
> > time instead of requiring a recompile; we probably don't save any
> > significant number of cycles by compiling this into the server.
> 
> FWIW, +1
> 
> We're already hurt by the small segments due to a similar phenomenon
> as the ssh case: TCP slow start. Designing the archive/recovery
> command to work around TCP slow start is quite complex, and bigger
> segments would just be a better thing.
> 
> Not to mention that bigger segments compress better.

This would be good time to rename pg_xlog and pg_clog directories too.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Write Ahead Logging for Hash Indexes
Next
From: Tom Lane
Date:
Subject: Re: Intermittent "cache lookup failed for type" buildfarm failures