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

From David Pacheco
Subject Re: Can PostgreSQL create new WAL files instead of reusing old ones?
Date
Msg-id CACukRjM68-khjN+LxzVAqi3FHR=Av+9HdnDqyONg4PoWdfni2g@mail.gmail.com
Whole thread Raw
In response to Re: Can PostgreSQL create new WAL files instead of reusing old ones?  (Jerry Jelinek <jerry.jelinek@joyent.com>)
Responses Re: Can PostgreSQL create new WAL files instead of reusing old ones?
List pgsql-general
On Wed, Jun 20, 2018 at 10:35 AM, Jerry Jelinek <jerry.jelinek@joyent.com> wrote:
As Dave described in his original email on this topic, we'd like to avoid recycling WAL files since that can cause performance issues when we have a read-modify-write on a file that has dropped out of the cache.

I have implemented a small change to allow WAL recycling to be disabled. It is visible at:

I'd appreciate getting any feedback on this.

Thanks,
Jerry



For reference, there's more context in this thread from several months ago:

I'll repeat the relevant summary here:

tl;dr: We've found that under many conditions, PostgreSQL's re-use of old
WAL files appears to significantly degrade query latency on ZFS.  The reason is
complicated and I have details below.  Has it been considered to make this
behavior tunable, to cause PostgreSQL to always create new WAL files
instead of re-using old ones?

Thanks,
Dave

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data
Next
From: Vik Fearing
Date:
Subject: Re: using pg_basebackup for point in time recovery