I am dealing with backup of databases. Now eventhough there are not many changes in the DB, it creates WAL file of 16 mb. Now because I am working on a application which takes full & inc backup of db after specific intervals..if for small changes it creates 16 mb files then storing them will eat up lot many space. As I am not having DB knowledge I am just assuming that it will create problems in terms of storage space. That is my concern. If you will explain this thing then it will help me in a good way :) Thank you. Alban Hertroys-3 wrote: > > On 8 Oct 2009, at 9:35, Mitesh51 wrote: > >> By setting postgres.conf params...log files are generated of 16 MB >> each. How >> can I reduce the size of this files? & can I force the log files to >> switch >> with any command as we do in mysql like flush log? where we force >> the new >> log creation ? > > > Why do you want to reduce the WAL file size? What problem are you > trying to solve? > > Alban Hertroys > > -- > If you can't see the forest for the trees, > cut the trees and you'll see there is no forest. > > > !DSPAM:737,4ace7bd211681560221775! > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/How-to-reduce-WAL-file-Size-tp25799623p25816266.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
