Freeze avoidance of very large table

Edit

Title

Topic

Server Features

Created

2015-04-20 07:47:41

Last modified

2016-03-11 17:37:18 (8 years, 1 month ago)

Latest email

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

Amit Kapila (amitkapila), Robert Haas (rhaas), Kyotaro Horiguchi (horiguti), Fujii Masao (masaofujii)Become reviewer

Committer

Robert Haas (rhaas)

Links

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