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

From Filip Rembiałkowski
Subject Re: Why so many xlogs?
Date
Msg-id AANLkTi=X2aSfO2sfaEtORRtUZ+TwOfX+h2hSqCwUt4Nr@mail.gmail.com
Whole thread Raw
In response to Why so many xlogs?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Why so many xlogs?  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
2010/11/1 hubert depesz lubaczewski <depesz@depesz.com>:

> as I understand, max number of xlog files in pg_xlog should be ( 1 + 2 *
> checkpoint_segments ).

why?

for a server overloaded with R/W transactions, it's possible to go beyond this.
checkpoints just do not keep up.
right now I have an 8.3 with checkpoint_segments=3, constantly running
pgbench and I see 8 WAL segments.

cheers
Filip

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: max_fsm_pages increase
Next
From: Carlos Mennens
Date:
Subject: Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?