Re: Decreasing WAL size effects

Jason Long wrote:
> I am planning on setting up PITR for my application.

> I also have to ship them off site using a T1 so setting the time to
> automatically switch files will just waste bandwidth if they are still
> going to be 16 MB anyway.
>
> *1.  What is the effect of recompiling and reducing the default size of
> the WAL files?

Increased I/O

> 2.  What is the minimum suggested size?

16 megs, the default.

> 3.  If I reduce the size how will this work if I try to save a document
> that is larger than the WAL size?

You will create more segments.

Joshua D. Drake