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 20160825195110.GA27671@momjian.us
Whole thread Raw
In response to Re: increasing the default WAL segment size  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Thu, Aug 25, 2016 at 04:21:33PM +0100, Simon Riggs wrote:
> If we do have the pain of change, should we also consider making WAL
> files variable length? What do we gain by having the files all the
> same size? ISTM better to have WAL files that vary in length up to 1GB
> in size.
> 
> (This is all about XLOG_SEG_SIZE; I presume XLOG_BLCKSZ can stay as it
> is, right?)

I think having WAL use variable length files would add complexity for
recycling WAL files.

--  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: Konstantin Knizhnik
Date:
Subject: Re: UPSERT strange behavior
Next
From: Robert Haas
Date:
Subject: Re: increasing the default WAL segment size