Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: [HACKERS] increasing the default WAL segment size
Date
Msg-id CA+TgmoZMOz_9kNYGf5zZRC2_XhhEoQ2+stRP1CNC+=Ua2CXDHA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] increasing the default WAL segment size  (David Steele <david@pgmasters.net>)
Responses Re: [HACKERS] increasing the default WAL segment size  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view 
On Mon, Mar 20, 2017 at 7:23 PM, David Steele <david@pgmasters.net> wrote:
> With 16MB WAL segments the filename neatly aligns with the LSN.  For
> example:
>
> WAL FILE 0000000100000001000000FE = LSN 1/FE000000
>
> This no longer holds true with this patch.

It is already possible to change the WAL segment size using the
configure option --with-wal-segsize, and I think the patch should be
consistent with whatever that existing option does.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] [POC] A better way to expand hash indexes.
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Our feature change policy