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 flat)
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           www.2ndQuadrant.com
 PostgreSQL Development, 24x7 Support, Training and Services


In response to

Responses

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-2014 The PostgreSQL Global Development Group