Re: Can PostgreSQL create new WAL files instead of reusing old ones?

From: Andres Freund <andres(at)anarazel(dot)de>
To: Adam Brusselback <adambrusselback(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can PostgreSQL create new WAL files instead of reusing old ones?
Date: 2018-06-22 19:07:59
Message-ID: 20180622190759.5hyjdxdpvfbckqec@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 2018-06-22 11:41:45 -0400, Adam Brusselback wrote:
> > Is there some way to make it auto-detect when it should be enabled? If
> not, please document that it should be used on ZFS and any other file
> system with CoW properties on files.

> In addition to this, wondering what type of performance regression this
> would show on something like ext4 (if any).

It's a *massive* regression on ext4 & xfs. You can very trivially
compare the performance of a new cluster (which doesn't have files to
recycle) against one that's running for a while.

Greetings,

Andres Freund

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clifford Snow 2018-06-23 23:06:19 Convert Existing Table to a Partition Table in PG10
Previous Message Adrian Klaver 2018-06-22 17:56:28 Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data