Too many .history file in pg_xlog takes lots of space

Hi team, 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: 156A.history => 156B.history Now it takes a lot of space about 800MB (5787 history file): -rw--- 1 pgsql pgsql 247K Mar 13 14:49 1568.history

Re: Too many .history file in pg_xlog takes lots of space

彭昱傑 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: > 156A.history => 156B.history > > Now it takes a lot of space about 800MB (5787 history file): > [...] > Is file 1570.history important? A

Re: Too many .history file in pg_xlog takes lots of space

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 : > 彭昱傑 wrote: > > My postgre version is 9.4.9, and I face a space issue. > > > > Every time I restart postgre