On Mon, Jan 9, 2012 at 4:58 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > rama <rsomaraju@xxxxxxxxxxx> writes: >> Due to the small file size I see thousands of files being generated and it >> takes for ever to list thousands of files from archive directory which >> stores 2 days worth of files. Sizing of WAL logs should be left to the >> choice of people using the software. Limiting to a very small random 16MB >> size isn't a good design. > > There are tradeoffs in the other direction too, but if you feel you must > have a different value, see configure's --with-wal-segsize option. Note > that you cannot change this without re-initdb. Is there a limit to the max size? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general