I know we've had many discussions about the defaults, so hey, let's bring
out the paint-cans and do the bikeshed all over again.
I would suggest a couple of changes to the default values in parameters
related to backup and replication.
The reason for this is to make it "easier to do the right thing by
default", meaning the defaults should be more suitable for new users to use
our tools in the default config.
Yes, these changes will increase some of the default overhead. My argument
against that is that anybody who actually cares about that overhead is
going to be tuning their database *anyway*, so they can just change things
back to the old defaults.
So, I suggest the following changes to the defaults:
And in pg_hba.conf, we enable the replication connections by default for
the superuser on local/localhost.
This will make it possible to actually take a proper backup (not just a
dump) off a default config cluster without having to do a restart first.
And it allows you to set up archiving with pg_receivexlog for full PITR.
I think the overhead of the two max parameters is really small, but they're
both dependent on the default wal_level. Yes, we've discussed it before. I
think it's time to make the change now.
I'm sure there are many more settings we could discuss the defaults for,
but this particular biikeshed is mine so I get to decide the initial
borders, even if I don't get to decide the colors :P