Re: WAL segmentes names in wrong order? - Mailing list pgsql-general

From Tom DalPozzo
Subject Re: WAL segmentes names in wrong order?
Date
Msg-id CAK77FCQ1MP3_5YkMaRdZtOv58k_MHGfXh4tcqwq_uoizHfFQ=A@mail.gmail.com
Whole thread Raw
In response to Re: WAL segmentes names in wrong order?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: WAL segmentes names in wrong order?  (David Steele <david@pgmasters.net>)
List pgsql-general
Hi, 
so if I understand right, the ...DE file's previous name, was less than ...C6, then it was renamed in big advance for later use. I was missing this advance.
Thanks!
Pupillo



2016-11-03 11:45 GMT+01:00 hubert depesz lubaczewski <depesz@depesz.com>:
On Thu, Nov 03, 2016 at 11:28:57AM +0100, Tom DalPozzo wrote:
> What am I missing?

David already explained, but you might want to read also:
https://www.depesz.com/2011/07/14/write-ahead-log-understanding-postgresql-conf-checkpoint_segments-checkpoint_timeout-checkpoint_warning/

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: WAL segmentes names in wrong order?
Next
From: Adrian Klaver
Date:
Subject: Re: Recover from corrupted database due to failing disk