Re: Too many .history file in pg_xlog takes lots of space - Mailing list pgsql-performance

From 彭昱傑
Subject Re: Too many .history file in pg_xlog takes lots of space
Date
Msg-id CALCPtXZOBUickEJqMV-YtcGbxUfwntwUX0rAWypuO6Rpf-JoQQ@mail.gmail.com
Whole thread Raw
In response to Re: Too many .history file in pg_xlog takes lots of space  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Too many .history file in pg_xlog takes lots of space  (Michael Paquier <michael@paquier.xyz>)
List pgsql-performance
Thank you.

It's useful information for me.
I will  examine my restart script, and study  point-in-time-recovery.
Also remove unused history file.

2018-03-14 13:56 GMT+08:00 Laurenz Albe <laurenz.albe@cybertec.at>:
彭昱傑 wrote:
> My postgre version is 9.4.9, and I face a space issue.
>
> Every time I restart postgre server, it generates a new history file:
> 0000156A.history =>  0000156B.history
>
> Now it takes a lot of space about 800MB (5787 history file):
> [...]
> Is  file 00001570.history important?

A new history file is created when a new timeline is opened,
which happens after point-in-time-recovery or promotion of
a physical standby server.

There must be something weird in the way you start PostgreSQL.
Examine the start script, maybe you can fix the problem.

These files are only necessary for point-in-time-recovery,
so you don't have to retain them any longer than you retain
your WAL archives.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Too many .history file in pg_xlog takes lots of space
Next
From: Michael Paquier
Date:
Subject: Re: Too many .history file in pg_xlog takes lots of space