Skip site navigation (1) Skip section navigation (2)

Re: formula about the number of WAL files

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: formula about the number of WAL files
Date: 2010-10-15 13:48:57
Message-ID: 1287150537.1725.1452.camel@ebony (view raw or whole thread)
Lists: pgsql-docs
On Fri, 2010-10-15 at 19:44 +0900, Fujii Masao wrote:

> As the result of the above, the maximum number of WAL files in
> pg_xlog is
>     (2 + checkpoint_completion_target) * checkpoint_segments + 1
>     or
>     wal_keep_segments + checkpoint_segments + 1
> So the original description seems to be correct. Am I missing
> something?

After some thought, I agree.

> # My previous proposal is definitely wrong. Sorry for noise.

I'd say the definition of wal_keep_segments isn't good, which is what is
causing the problem here. Will sort that out another day.

I will update the current code with some comments, so this doesn't
happen again. Will do this on Tuesday now, no time left here.

 Simon Riggs 
 PostgreSQL Development, 24x7 Support, Training and Services

In response to


pgsql-docs by date

Next:From: Peter EisentrautDate: 2010-10-15 15:26:59
Subject: Re: Documenting removal of nonnullvalue() and friends
Previous:From: Fujii MasaoDate: 2010-10-15 10:44:24
Subject: Re: formula about the number of WAL files

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group