Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: Too many .history file in pg_xlog takes lots of space
Date
Msg-id 20180314134958.yzp2pze2s2yajf7k@alvherre.pgsql
Whole thread Raw
In response to Too many .history file in pg_xlog takes lots of space  (彭昱傑 <k872892@gmail.com>)
Responses Re: Too many .history file in pg_xlog takes lots of space
List pgsql-performance
Tree view 
彭昱傑 wrote:

> My postgre version is 9.4.9, and I face a space issue.

Latest in 9.4 is 9.4.17, so you're missing about two years of bug fixes.

> Every time I restart postgre server, it generates a new history file:

That's strange -- it shouldn't happen ... sounds like you're causing a
crash each time you restart.  Are you using immediate mode in shutdown
maybe?  If so, don't; use fast mode instead.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-performance by date:

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