-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Ron Somaraju Sent: Monday, January 09, 2012 8:21 PM To: Tom Lane Cc: Scott Marlowe; pgsql-general@xxxxxxxxxxxxxx Subject: Re: How do you change the size of the WAL files? Once again, pros and cons should be left to users discretion because one may have latest and greatest hardware and network resources. For example a SSD on a fiber channel on a high speed network. ---------------------------------------------------------- And determining whether such a run-time configuration is feasible should be left to programmer's discretion since they have the best chance of knowing all the different parts of the system that relate to the feature/ability in question. You are right in that everything should be end-user configurable but maybe there are reasons that is not possible or desirable in specific situations. Regardless, the designers still have to pick reasonable defaults since the configuring 500 settings just to install the software is not realistic or desirable in its own right. While your concerns and reasoning are well-founded currently the capability to dynamically adjust the WAL file size is not present and so the question becomes whether you can convince the community to add such functionality in a timely enough fashion or whether it is important enough to you to contract one of the service providers to research and make the necessary modifications. Simply being right doesn't mean that the current (wrong) state is going to go away - especially since it isn't broken but rather is not as flexible as it possibly could be. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
