Re: Why so many xlogs?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why so many xlogs?
Date: 2010-11-01 18:27:14
Message-ID: 20101101182714.GA6437@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-11-01 18:27:48 Re: Why so many xlogs?
Previous Message Filip Rembiałkowski 2010-11-01 18:24:29 Re: JDBC Transactions