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

From Alvaro Herrera
Subject Re: patch to allow disable of WAL recycling
Date
Msg-id 20180822140617.z37wlyn2dp7kryts@alvherre.pgsql
Whole thread Raw
In response to Re: patch to allow disable of WAL recycling  (Jerry Jelinek <jerry.jelinek@joyent.com>)
Responses Re: patch to allow disable of WAL recycling
List pgsql-hackers
On 2018-Aug-21, Jerry Jelinek wrote:

> Tomas,
> 
> Thanks for doing all of this testing. Your testing and results are much
> more detailed than anything I did. Please let me know if there is any
> follow-up that I should attempt.

Either I completely misread these charts, or there is practically no
point to disabling WAL recycling (except on btrfs, but then nobody in
their right minds would use it for Postgres given these numbers anyway).
I suppose that the use case that was initially proposed (ZFS) has not
yet been tested so we shouldn't reject this patch immediately, but
perhaps what Joyent people should be doing now is running Tomas' test
script on ZFS and see what the results look like.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: AYahorau@ibagroup.eu
Date:
Subject: Re: Adding TCP_USER_TIMEOUT support for libpq/psqlodbc
Next
From: Andres Freund
Date:
Subject: Re: patch to allow disable of WAL recycling