Thank you.
If I understand it well, we can build a new postgreSQL server, by setting this value into "configure" file?
--with-wal-segsize=SEGSIZE becomes --with-wal-segsize=1024 ??
_______________________________
Gianfranco Cocco
Gruppo DBA Torino
Managed Operations - Data Center Factory
gianfranco.cocco@eng.it
Engineering.MO S.p.A
Corso Mortara, 22 - 10149 Torino
Tel. 011 19449548 (SHORT CODE: 676548)
www.eng.it
___________________________
-----Messaggio originale-----
Da: Michael Paquier [mailto:michael.paquier@gmail.com]
Inviato: lunedì 12 giugno 2017 23:26
A: Jeff Janes <jeff.janes@gmail.com>
Cc: Cocco Gianfranco <Gianfranco.Cocco@eng.it>; pgsql-performance@postgresql.org; pgsql-bugs@postgresql.org; DBA <DBA@italiaonline.it>
Oggetto: Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
On Tue, Jun 13, 2017 at 2:27 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> But there is something preventing it. wal_segsize cannot exceed 64MB
> in 9.2. v10 will be the first version which will allow sizes above 64MB.
Yes, indeed. I have misread --with-segsize and --with-wal-segsize in the docs. Sorry for the confusion.
--
Michael