Hello hackers,
I'm no PG hacker, so maybe I'm completely wrong, so sorry if I have wasted your 
time. I try to make the best out of Tom Lanes comment.

What would happen if there's a database on a server with initdb (or whatever) 
parameter -with-wal-size=64MB and later someone decides to make it the master 
in a replicated system and has a slave without that parameter? Would the slave 
work with the "different" wal size of the master? How could be guaranteed that 
in such a scenario the replication either works correctly or failes with a 
meaningful error message?

But in general I thing a more flexible WAL size is a good idea. 
To answer Andres: You have found one of the (few?) users to adjust initdb 


    Robert Haas <robertmh...@gmail.com> schrieb am 6:43 Donnerstag, 25.August 

 On Thu, Aug 25, 2016 at 12:35 AM, Andres Freund <and...@anarazel.de> wrote:
> FWIW, I'm also doubtful that investing time into making this initdb
> configurable is a good use of time: The number of users that'll adjust
> initdb time parameters is going to be fairly small.

I have to admit that I was skeptical about the idea of doing anything
about this at all the first few times it came up.  16MB ought to be
good enough for anyone!  However, the time between beatings has now
gotten short enough that the bruises don't have time to heal before
the next beating arrives from a completely different customer.  I try
not to hold my views so firmly as to be impervious to contrary

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

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:


Reply via email to