From: Simon Riggs <simon@2ndQuadrant.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: formula about the number of WAL files
Date: Fri, 15 Oct 2010 14:48:57 +0100
Message-ID: <1287150537.1725.1452.camel@ebony> (raw)
In-Reply-To: <AANLkTi=e=oR54OuxAw88=dtV4wt0e5edMiGaeZtBVcKO@mail.gmail.com>
References: <AANLkTik0sqru9oMZeTL4vnFkAaDYZB=-Meonv9gnroiu@mail.gmail.com>
<1287134396.1725.1300.camel@ebony>
<AANLkTi=e=oR54OuxAw88=dtV4wt0e5edMiGaeZtBVcKO@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: simon@2ndQuadrant.com, masao.fujii@gmail.com
Subject: Re: formula about the number of WAL files
In-Reply-To: <1287150537.1725.1452.camel@ebony>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox