Re: Decreasing WAL size effects - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Decreasing WAL size effects
Date
Msg-id 4907FF00.4040008@commandprompt.com
Whole thread Raw
In response to Decreasing WAL size effects  (Jason Long <mailing.list@supernovasoftware.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Problem with sql
Next
From: "Ravi Chemudugunta"
Date:
Subject: using plpgsql debuggers