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

From Stephen Frost
Subject Re: increasing the default WAL segment size
Date
Msg-id 20170325163011.GZ9812@tamriel.snowman.net
Whole thread Raw
In response to Re: increasing the default WAL segment size  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Peter,

* Peter Eisentraut (peter.eisentraut@2ndquadrant.com) wrote:
> On 3/24/17 19:13, David Steele wrote:
> > Behavior for the current default of 16MB is unchanged, and all other
> > sizes go through a logical progression.
>
> Just at a glance, without analyzing the math behind it, this scheme
> seems super confusing.

Compared to:

1GB:
000000010000000000000001
000000010000000000000002
000000010000000000000003
000000010000000100000000

...?

Having the naming no longer match the LSN and also, seemingly, jump
randomly, strikes me as very confusing.  At least with the LSN-based
approach, we aren't jumping randomly but exactly in-line with what the
starting LSN of the file is, and always by the same amount (in hex).

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: Faster Expression Processing v4
Next
From: Dave Page
Date:
Subject: Re: Monitoring roles patch