Freeze avoidance of very large table

Edit
ID 221
Title Freeze avoidance of very large table
Topic Server Features
Created 2015-04-20 07:47:41
Last modified 2016-03-11 17:37:18 (8 years, 7 months ago)
Latest email 2016-03-11 17:52:42 (8 years, 7 months ago)
Status
2016-03: Committed
2016-01: Moved to next CF
2015-11: Moved to next CF
2015-09: Moved to next CF
Target version
Authors Masahiko Sawada (masahikosawada)
Reviewers Kyotaro Horiguchi (horiguti), Fujii Masao (masaofujii), Amit Kapila (amitkapila), Robert Haas (rhaas)Become reviewer
Committer Robert Haas (rhaas)
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/221
git checkout commitfest/cf/221
Emails
Freeze avoidance of very large table.
First at 2015-04-03 05:59:41 by Sawada Masahiko <sawada.mshk at gmail.com>
Latest at 2016-03-11 17:52:42 by "Joshua D. Drake" <jd at commandprompt.com>
Latest attachment (000_pgupgrade_rewrite_vm_v42.patch) at 2016-03-11 03:47:01 from Masahiko Sawada <sawada.mshk at gmail.com>
    Attachment (000_pgupgrade_rewrite_vm_v42.patch) at 2016-03-11 03:47:01 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (001_optimize_vacuum_by_frozen_bit_v40.patch) at 2016-03-10 18:41:55 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (pgupgrade-rewrite-v41.patch) at 2016-03-10 16:03:29 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (000_pgupgrade_rewrite_vm_v40.patch) at 2016-03-10 13:51:20 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (optimize-scanall-vacuum.patch) at 2016-03-10 10:43:08 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (000_pgupgrade_rewrite_vm_v39.patch) at 2016-03-10 06:27:09 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_pgupgrade_rewrites_vm_v38.patch) at 2016-03-09 14:09:46 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (fix_typo.patch) at 2016-03-08 17:59:18 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (all-frozen-doc.patch) at 2016-03-08 17:33:02 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (Add_condition_to_pg_visibility.patch) at 2016-03-08 12:26:01 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (pg_visibility-v2.patch) at 2016-03-08 00:50:35 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (no-pd-all-frozen.patch) at 2016-03-07 19:03:08 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (000_optimize_vacuum_using_freezemap_v37.patch) at 2016-03-07 17:41:57 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (pg_visibilitymap-v1.patch) at 2016-03-02 02:51:55 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v36.patch) at 2016-02-18 08:45:17 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (Remove_page_conversion_from_pg_upgrade_v2.patch) at 2016-02-17 07:44:43 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (Remove_page_conversion_from_pg_upgrade.patch) at 2016-02-17 07:29:01 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v35.patch) at 2016-02-14 05:19:38 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v34.patch) at 2016-02-03 17:32:29 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v33.patch) at 2016-01-17 13:00:20 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v32.patch) at 2016-01-12 15:16:59 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (pgupgrade-fix.patch) at 2015-12-18 06:22:23 from Michael Paquier <michael.paquier at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v31.patch) at 2015-12-17 18:17:47 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v30.patch) at 2015-12-03 02:24:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v29.patch) at 2015-12-01 18:40:09 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v28.patch) at 2015-11-30 17:18:04 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v27.patch) at 2015-11-24 23:13:31 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v26.patch) at 2015-11-22 16:16:34 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v25.patch) at 2015-11-19 14:44:05 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v24.patch) at 2015-11-18 06:32:49 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_page_info_map_v23.patch) at 2015-11-13 05:36:54 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_page_info_map_v22.patch) at 2015-11-12 23:18:43 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v21.patch) at 2015-10-30 00:33:13 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v20.patch) at 2015-10-29 16:26:06 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v19.patch) at 2015-10-22 17:10:11 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v18.patch) at 2015-10-21 00:05:40 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v17.patch) at 2015-10-08 17:26:54 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v16.patch) at 2015-10-05 10:31:18 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v15.patch) at 2015-10-02 17:24:46 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v14.patch) at 2015-10-02 11:14:05 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v13.patch) at 2015-09-18 11:14:35 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v12.patch) at 2015-09-03 17:23:27 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v12.patch) at 2015-08-26 16:54:24 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (001_diagnostic_function_for_visibility_map_v11.patch) at 2015-08-18 11:27:24 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v10.patch) at 2015-07-29 12:40:22 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v9.patch) at 2015-07-16 11:51:09 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v8.patch) at 2015-07-10 14:11:45 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v7.patch) at 2015-07-10 05:41:50 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v6.patch) at 2015-07-09 18:05:26 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (001_visibilitymap_test_function.patch) at 2015-07-07 14:18:05 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v5.patch) at 2015-07-06 15:46:44 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v4.patch) at 2015-07-02 15:30:07 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v3.patch) at 2015-07-01 15:13:46 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v2.patch) at 2015-05-28 02:34:28 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_add_frozen_bit_into_visibilitymap_v1.patch) at 2015-04-30 11:07:06 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_frozenmap_WIP.patch) at 2015-04-20 07:45:34 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (000_read_only_table_v0.patch) at 2015-04-03 05:59:41 from Sawada Masahiko <sawada.mshk at gmail.com> (Patch: Yes)
History
When Who What
2016-03-11 17:37:18 Robert Haas (rhaas) Closed in commitfest 2016-03 with status: Committed
2016-03-11 09:33:29 Simon Riggs (simon) Removed simon from reviewers
2016-03-10 23:28:43 Robert Haas (rhaas) New status: Ready for Committer
2016-03-10 23:28:34 Robert Haas (rhaas) Added rhaas as reviewer
2016-03-10 23:28:30 Robert Haas (rhaas) Added rhaas as committer
2016-02-15 05:41:50 Kyotaro Horiguchi (horiguti) Changed reviewers to Kyotaro Horiguchi (horiguti), Fujii Masao (masaofujii), Amit Kapila (amitkapila), Simon Riggs (simon)
2016-02-02 13:04:05 Álvaro Herrera (alvherre) Closed in commitfest 2016-01 with status: Moved to next CF
2015-12-17 23:58:40 Michael Paquier (michael-kun) Closed in commitfest 2015-11 with status: Moved to next CF
2015-11-12 23:20:22 Masahiko Sawada (masahikosawada) New status: Needs review
2015-11-02 13:05:44 Amit Kapila (amitkapila) New status: Waiting on Author
2015-10-30 23:32:29 Michael Paquier (michael-kun) Closed in commitfest 2015-09 with status: Moved to next CF
2015-10-05 10:36:04 Masahiko Sawada (masahikosawada) New status: Needs review
2015-10-02 03:42:30 Fujii Masao (masaofujii) New status: Waiting on Author
2015-10-02 03:42:22 Fujii Masao (masaofujii) Added masaofujii as reviewer
2015-09-04 22:36:01 Simon Riggs (simon) Closed in commitfest 2015-09 with status: Moved to next CF
2015-09-04 01:37:54 Fujii Masao (masaofujii) New status: Waiting on Author
2015-07-14 15:56:11 Simon Riggs (simon) Closed in commitfest 2015-07 with status: Moved to next CF
2015-07-10 13:45:43 Fujii Masao (masaofujii) New status: Waiting on Author
2015-07-10 05:42:15 Masahiko Sawada (masahikosawada) New status: Needs review
2015-07-07 11:50:29 Amit Kapila (amitkapila) New status: Waiting on Author
2015-07-07 11:50:18 Amit Kapila (amitkapila) Added amitkapila as reviewer
2015-07-02 16:30:37 Simon Riggs (simon) Added simon as reviewer
2015-05-15 10:42:00 Masahiko Sawada (masahikosawada) Changed name to Freeze avoidance of very large table
2015-05-01 01:45:30 Masahiko Sawada (masahikosawada) Deleted annotation "The second version path that adds a extra bit into visibility map." from CAD21AoB5mr4XdkT54McS6z6QvPdqkeWwcSvqK_u=gvD-V-HGpw@mail.gmail.com
2015-04-30 11:18:08 Masahiko Sawada (masahikosawada) Added annotation "The second version path that adds a extra bit into visibility map." to CAD21AoB5mr4XdkT54McS6z6QvPdqkeWwcSvqK_u=gvD-V-HGpw@mail.gmail.com
2015-04-20 07:48:59 Masahiko Sawada (masahikosawada) Changed authors to Masahiko Sawada (masahikosawada)
2015-04-20 07:47:41 Masahiko Sawada (masahikosawada) Attached mail thread CAD21AoA9wRAynBnzuMm219wdHCgFY0aQ2iargVTGvJvpn_pODw@mail.gmail.com
2015-04-20 07:47:41 Masahiko Sawada (masahikosawada) Created patch record
Edit