Avoid creation of the free space map for small tables

Edit
ID 1821
Title Avoid creation of the free space map for small tables
Topic Miscellaneous
Created 2018-10-05 18:54:30
Last modified 2019-03-18 02:26:24 (5 years, 7 months ago)
Latest email 2019-03-18 02:28:51 (5 years, 7 months ago)
Status
2019-03: Committed
2019-01: Moved to next CF
2018-11: Moved to next CF
Target version 12
Authors John Naylor (john.naylor)
Reviewers Amit Kapila (amitkapila)Become reviewer
Committer Amit Kapila (amitkapila)
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/1821
git checkout commitfest/cf/1821
Emails
WIP: Avoid creation of the free space map for small tables
First at 2018-10-05 18:47:11 by John Naylor <jcnaylor at gmail.com>
Latest at 2019-03-18 02:28:51 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (correct-local-map-comments.patch) at 2019-03-15 10:10:16 from John Naylor <john.naylor at 2ndquadrant.com>
    Attachment (correct-local-map-comments.patch) at 2019-03-15 10:10:16 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v24-0001-During-pg_upgrade-conditionally-skip-transfer-of-FSM.patch) at 2019-03-14 06:17:29 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-During-pg_upgrade-conditionally-skip-transfer-of.patch) at 2019-03-10 14:16:48 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (jcn-16blk-regress.diffs) at 2019-02-23 08:01:11 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v6-0001-Add-more-tests-for-FSM.patch) at 2019-02-23 07:54:18 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (regression.16.diffs) at 2019-02-22 02:59:27 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-more-tests-for-FSM.patch) at 2019-02-21 14:37:46 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-more-tests-for-FSM.patch) at 2019-02-21 06:58:16 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-more-tests-for-FSM.patch) at 2019-02-20 12:55:58 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Document-that-functions-that-use-the-FSM-for-will.patch) at 2019-02-20 11:09:09 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Improve-FSM-regression-test.patch) at 2019-02-11 17:18:28 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v1-0001-Improve-FSM-regression-test.patch) at 2019-02-05 09:55:28 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v22-0001-Avoid-creation-of-the-free-space-map-for-small-heap-.patch) at 2019-02-03 13:06:08 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (revert-pageinspect.patch) at 2019-01-31 13:53:44 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v21-0001-Avoid-creation-of-the-free-space-map-for-small-heap-.patch) at 2019-01-31 12:33:25 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Avoid-creation-of-the-free-space-map-for-small-heap-.patch) at 2019-01-31 05:36:52 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (simple-regression-test-plus-ctid-loop.patch) at 2019-01-30 14:41:46 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (remove-reliance-on-vacuum-for-fsm-regression-test.patch) at 2019-01-30 09:56:32 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v19-0001-Avoid-creation-of-the-free-space-map-for-small-heap-.patch) at 2019-01-30 03:33:32 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (change_pgbench_test_1.patch) at 2019-01-29 10:55:52 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v18-0002-Avoid-creation-of-the-free-space-map-for-small-heap-.patch) at 2019-01-29 00:29:02 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v21-0003-During-pg_upgrade-conditionally-skip-transfer-of.patch) at 2019-01-27 21:03:22 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v20-0003-During-pg_upgrade-conditionally-skip-transfer-of-FSM.patch) at 2019-01-26 13:14:30 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v19-0003-During-pg_upgrade-conditionally-skip-transfer-of.patch) at 2019-01-25 23:35:30 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v02-0001-In-bootstrap-mode-don-t-allow-the-creation-of-files-.patch) at 2019-01-24 03:44:19 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v02-0001-In-bootstrap-mode-don-t-allow-the-creation-of-files-.patch) at 2019-01-23 12:08:52 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Avoid-creation-of-the-free-space-map-for-small-h.patch) at 2019-01-19 23:49:08 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v15-0001-Avoid-creation-of-the-free-space-map-for-small-heap-.patch) at 2019-01-19 13:05:49 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Avoid-creation-of-the-free-space-map-for-small-h.patch) at 2019-01-17 17:43:36 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (v13-0001-Avoid-creation-of-the-free-space-map-for-small-heap-.patch) at 2019-01-16 13:41:14 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Avoid-creation-of-the-free-space-map-for-small-h.patch) at 2019-01-10 22:24:10 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (fsm-last-page-only.patch) at 2019-01-07 20:56:59 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (callgrind_report.zip) at 2019-01-04 02:57:54 from Mithun Cy <mithun.cy at enterprisedb.com> (Patch: No)
    Attachment (callgrind.out.115655_before_patch) at 2019-01-04 02:53:00 from Mithun Cy <mithun.cy at enterprisedb.com> (Patch: No)
    Attachment (remove-bootstrap-case-md.patch) at 2018-12-12 21:48:22 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Avoid-creation-of-the-free-space-map-for-small-table.patch) at 2018-12-08 13:05:20 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Avoid-creation-of-the-free-space-map-for-small-t.patch) at 2018-12-06 17:23:28 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (fsm-copy-setup.sql) at 2018-12-01 07:12:11 from John Naylor <jcnaylor at gmail.com> (Patch: No)
    Attachment (v9-0001-Avoid-creation-of-the-free-space-map-for-small-ta.patch) at 2018-11-29 09:37:30 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Minor-cosmetic-adjustments-for-consistency.patch) at 2018-11-23 06:26:43 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (fsm-copy-test-v2.sql) at 2018-11-04 08:26:34 from John Naylor <jcnaylor at gmail.com> (Patch: No)
    Attachment (v7-0001-Avoid-creation-of-the-free-space-map-for-small-ta.patch) at 2018-10-31 08:12:08 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (fsm-copy-test.sql) at 2018-10-23 13:42:02 from John Naylor <jcnaylor at gmail.com> (Patch: No)
    Attachment (v6-0001-Avoid-creation-of-the-free-space-map-for-small-ta.patch) at 2018-10-22 06:44:27 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Avoid-creation-of-the-free-space-map-for-small-ta.patch) at 2018-10-16 10:57:25 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Avoid-creation-of-the-free-space-map-for-small-ta.patch) at 2018-10-14 16:29:28 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Avoid-creation-of-the-free-space-map-for-small-ta.patch) at 2018-10-13 19:39:39 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Avoid-creation-of-the-free-space-map-for-small-ta.patch) at 2018-10-07 15:17:24 from John Naylor <jcnaylor at gmail.com> (Patch: Yes)
    Attachment (fsmtest.sql) at 2018-10-05 18:47:11 from John Naylor <jcnaylor at gmail.com> (Patch: No)
History
When Who What
2019-03-18 02:26:24 Amit Kapila (amitkapila) Closed in commitfest 2019-03 with status: Committed
2019-03-18 02:26:24 Amit Kapila (amitkapila) Changed committer to amitkapila
2019-02-14 19:42:41 Andres Freund (andresfreund) Changed targetversion to 12
2019-02-04 02:17:13 Michael Paquier (michael-kun) Closed in commitfest 2019-01 with status: Moved to next CF
2018-12-01 13:35:32 Dmitry Dolgov (erthalion) Closed in commitfest 2018-11 with status: Moved to next CF
2018-10-22 08:48:53 John Naylor (john.naylor) New status: Needs review
2018-10-16 13:03:43 Amit Kapila (amitkapila) New status: Waiting on Author
2018-10-16 13:03:37 Amit Kapila (amitkapila) Changed reviewers to Amit Kapila (amitkapila)
2018-10-07 19:10:00 John Naylor (john.naylor) New status: Needs review
2018-10-06 08:54:28 John Naylor (john.naylor) New status: Waiting on Author
2018-10-05 18:55:03 John Naylor (john.naylor) Changed authors to John Naylor (john.naylor)
2018-10-05 18:54:30 John Naylor (john.naylor) Attached mail thread CAJVSVGWvB13PzpbLEecFuGFc5V2fsO736BsdTakPiPAcdMM5tQ@mail.gmail.com
2018-10-05 18:54:30 John Naylor (john.naylor) Created patch record
Edit