Re: How do you change the size of the WAL files? - Mailing list pgsql-general

From Tom Lane
Subject Re: How do you change the size of the WAL files?
Date
Msg-id 6603.1326153496@sss.pgh.pa.us
Whole thread Raw
In response to Re: How do you change the size of the WAL files?  (rama <rsomaraju@masergy.com>)
Responses Re: How do you change the size of the WAL files?  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
rama <rsomaraju@masergy.com> 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

pgsql-general by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Re: Time to move table to new tablespace
Next
From: Scott Marlowe
Date:
Subject: Re: queries timeout during backup postgres database