Postgres Pro
Downloads
Home   >   mailing lists

Re: patch to allow disable of WAL recycling - Mailing list pgsql-hackers

From Jerry Jelinek
Subject Re: patch to allow disable of WAL recycling
Date
Msg-id CACPQ5FoLYA3eTOr6aYQ1-mp2tS2Npu3fcUFddhCJ-UeiAXiw0A@mail.gmail.com
Whole thread Raw
In response to patch to allow disable of WAL recycling  (Jerry Jelinek <jerry.jelinek@joyent.com>)
Responses Re: patch to allow disable of WAL recycling  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
I've gotten a wide variety of feedback on the proposed patch. The comments range from rough approval through various discussion about alternative solutions. At this point I am unsure if this patch is rejected or if it would be accepted once I had the updated man page changes that were discussed last week.

I have attached an updated patch which does incorporate man page changes, in case that is the blocker. However, if this patch is simply rejected, I'd appreciate it if I could get a definitive statement to that effect.

Thanks,
Jerry


On Tue, Jun 26, 2018 at 7:35 AM, Jerry Jelinek <jerry.jelinek@joyent.com> wrote:
Hello All,

Attached is a patch to provide an option to disable WAL recycling. We have found that this can help performance by eliminating read-modify-write behavior on old WAL files that are no longer resident in the filesystem cache. The is a lot more detail on the background of the motivation for this in the following thread.


A similar change has been tested against our 9.6 branch that we're currently running, but the attached patch is against master.

Thanks,
Jerry


Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PG-11] Potential bug related to INCLUDE clause of CREATE INDEX
Next
From: Robert Haas
Date:
Subject: Re: Postgres, fsync, and OSs (specifically linux)