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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general