Improve WAL on COW filesystems

2031

Title

Topic

Performance

Created

2019-02-27 23:21:18

Last modified

2019-04-02 01:57:17 (5 years, 7 months ago)

Latest email

2019-04-02 15:35:38 (5 years, 7 months ago)

Status

2019-03: Committed

Target version

Authors

Jerry Jelinek (jerryj)

Reviewers

Álvaro Herrera (alvherre)Become reviewer

Committer

Thomas Munro (macdice)

Links

CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2031
git checkout commitfest/cf/2031

Emails

patch to allow disable of WAL recycling: First at 2018-06-26 13:35:57 by Jerry Jelinek <jerry.jelinek at joyent.com>
Latest at 2019-04-02 15:35:38 by Jerry Jelinek <jerry.jelinek at joyent.com>
Latest attachment (0001-Add-wal_recycle-and-wal_init_zero-GUCs.patch) at 2019-03-29 00:09:46 from Thomas Munro <thomas.munro at gmail.com>
    Attachment (0001-Add-wal_recycle-and-wal_init_zero-GUCs.patch) at 2019-03-29 00:09:46 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0001-wal_recycle-and-wal_init_zero.patch) at 2019-03-26 19:24:47 from Jerry Jelinek <jerry.jelinek at joyent.com> (Patch: Yes)
    Attachment (0001-wal_recycle-and-wal_init_zero.patch) at 2019-03-07 21:12:59 from Jerry Jelinek <jerry.jelinek at joyent.com> (Patch: Yes)
    Attachment (0001-cow-filesystem.patch) at 2019-03-05 22:52:34 from Jerry Jelinek <jerry.jelinek at joyent.com> (Patch: Yes)
    Attachment (v2-0001-pg_wal-on-COW-fs.patch) at 2019-02-27 23:10:10 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-cow-filesystem.patch) at 2019-02-05 19:05:46 from Jerry Jelinek <jerry.jelinek at joyent.com> (Patch: Yes)
    Attachment (ext4-sata.pdf) at 2018-09-04 18:41:11 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (zfs-sata.pdf) at 2018-08-31 22:49:26 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (lvm-ext4-snapshots.pdf) at 2018-08-26 22:14:22 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (btrfs.pdf) at 2018-08-16 21:43:25 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (v2-0001-Fix-calculation-base-of-WAL-recycling.patch) at 2018-07-19 03:51:17 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Fix-calculation-base-of-WAL-recycling.patch) at 2018-07-19 03:37:26 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-option-to-disable-WAL-recycling.patch) at 2018-07-18 19:22:59 from Jerry Jelinek <jerry.jelinek at joyent.com> (Patch: Yes)
    Attachment (0001-option-to-disable-WAL-recycling.patch) at 2018-06-26 13:35:57 from Jerry Jelinek <jerry.jelinek at joyent.com> (Patch: Yes)

History

When	Who	What
2019-04-02 01:57:17	Thomas Munro (macdice)	Closed in commitfest 2019-03 with status: Committed
2019-04-02 01:57:17	Thomas Munro (macdice)	Changed committer to macdice
2019-02-27 23:21:38	Álvaro Herrera (alvherre)	Changed targetversion to 12
2019-02-27 23:21:38	Álvaro Herrera (alvherre)	Changed authors to Jerry Jelinek (jerryj)
2019-02-27 23:21:38	Álvaro Herrera (alvherre)	Changed reviewers to Álvaro Herrera (alvherre)
2019-02-27 23:21:19	Álvaro Herrera (alvherre)	Attached mail thread CACPQ5Fo00QR7LNAcd1ZjgoBi4y97+K760YABs0vQHH5dLdkkMA@mail.gmail.com
2019-02-27 23:21:18	Álvaro Herrera (alvherre)	Created patch record