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

From John R Pierce
Subject Re: How do you change the size of the WAL files?
Date
Msg-id 4F0B7EA2.5050302@hogranch.com
Whole thread Raw
In response to Re: How do you change the size of the WAL files?  (rama <rsomaraju@masergy.com>)
List pgsql-general
On 01/09/12 10:45 AM, rama wrote:
> 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.

16MB isn't that small of a file, if htey were 8K or somethng, I'd see a
problem.     One issue is, when the checkpoint timeout occurs, it starts
a new WAL file whether the current one is full or not.  if the file size
is larger, more space would be wasted.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


pgsql-general by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Re: Side effects of moving an index to a new tablespace
Next
From: Ondrej Ivanič
Date:
Subject: Re: Time to move table to new tablespace