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, 8 months ago)

Latest email 2016-03-11 17:52:42 (8 years, 8 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