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