Re: Why so many xlogs? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Why so many xlogs?
Date
Msg-id 20101101182714.GA6437@depesz.com
Whole thread Raw
In response to Re: Why so many xlogs?  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: Why so many xlogs?  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-general
On Mon, Nov 01, 2010 at 07:22:50PM +0100, Cédric Villemain wrote:
> > as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
> > checkpoint_segments ).
> (2 + checkpoint_completion_target) * checkpoint_segments + 1
> => 291

this is formula gave to me by rhodiumtoad on irc, but we tested with lower
checkpoint_completion_target and it didn't change *anything*.

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: JDBC Transactions
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Why so many xlogs?