Re: Can PostgreSQL create new WAL files instead of reusing old ones? - Mailing list pgsql-general

From Andres Freund
Subject Re: Can PostgreSQL create new WAL files instead of reusing old ones?
Date
Msg-id 20180622190759.5hyjdxdpvfbckqec@alap3.anarazel.de
Whole thread Raw
In response to Re: Can PostgreSQL create new WAL files instead of reusing old ones?  (Adam Brusselback <adambrusselback@gmail.com>)
List 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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data
Next
From: Clifford Snow
Date:
Subject: Convert Existing Table to a Partition Table in PG10