Hi, On 2015-02-02 08:36:41 -0500, Robert Haas wrote: > Also, I'd like to propose that we set the default value of > max_checkpoint_segments/checkpoint_wal_size to something at least an > order of magnitude larger than the current default setting.
+1 I think we need to increase checkpoint_timeout too - that's actually just as important for the default experience from my pov. 5 minutes often just unnecessarily generates FPWs en masse. > I'll open the bidding at 1600MB (aka 100). Fine with me. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers