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

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: 彭昱傑 <k872892(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Too many .history file in pg_xlog takes lots of space
Date: 2018-03-14 13:49:58
Message-ID: 20180314134958.yzp2pze2s2yajf7k@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

彭昱傑 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2018-03-14 15:29:44 Re: Too many .history file in pg_xlog takes lots of space
Previous Message Michael Paquier 2018-03-14 07:04:43 Re: Too many .history file in pg_xlog takes lots of space