20210111-v13-regression.diffs

application/octet-stream

Filename: 20210111-v13-regression.diffs
Type: application/octet-stream
Part: 0
Message: Re: Deleting older versions in unique indexes to avoid page splits
diff -U3 /var/lib/postgresql/src/postgresql/src/test/regress/expected/explain.out /var/lib/postgresql/src/postgresql/src/test/regress/results/explain.out
--- /var/lib/postgresql/src/postgresql/src/test/regress/expected/explain.out    2020-10-27 18:36:47.882121747 +0000
+++ /var/lib/postgresql/src/postgresql/src/test/regress/results/explain.out     2021-01-11 20:11:07.187762844 +0000
@@ -106,7 +106,9 @@
        "Local Dirtied Blocks": N,  +
        "Local Written Blocks": N,  +
        "Temp Read Blocks": N,      +
-       "Temp Written Blocks": N    +
+       "Temp Written Blocks": N,   +
+       "I/O Read Time": N.N,       +
+       "I/O Write Time": N.N       +
      },                            +
      "Planning": {                 +
        "Shared Hit Blocks": N,     +
@@ -118,7 +120,9 @@
        "Local Dirtied Blocks": N,  +
        "Local Written Blocks": N,  +
        "Temp Read Blocks": N,      +
-       "Temp Written Blocks": N    +
+       "Temp Written Blocks": N,   +
+       "I/O Read Time": N.N,       +
+       "I/O Write Time": N.N       +
      },                            +
      "Planning Time": N.N,         +
      "Triggers": [                 +
@@ -156,6 +160,8 @@
        <Local-Written-Blocks>N</Local-Written-Blocks>  +
        <Temp-Read-Blocks>N</Temp-Read-Blocks>          +
        <Temp-Written-Blocks>N</Temp-Written-Blocks>    +
+       <I-O-Read-Time>N.N</I-O-Read-Time>              +
+       <I-O-Write-Time>N.N</I-O-Write-Time>            +
      </Plan>                                           +
      <Planning>                                        +
        <Shared-Hit-Blocks>N</Shared-Hit-Blocks>        +
@@ -168,6 +174,8 @@
        <Local-Written-Blocks>N</Local-Written-Blocks>  +
        <Temp-Read-Blocks>N</Temp-Read-Blocks>          +
        <Temp-Written-Blocks>N</Temp-Written-Blocks>    +
+       <I-O-Read-Time>N.N</I-O-Read-Time>              +
+       <I-O-Write-Time>N.N</I-O-Write-Time>            +
      </Planning>                                       +
      <Planning-Time>N.N</Planning-Time>                +
      <Triggers>                                        +
@@ -203,6 +211,8 @@
      Local Written Blocks: N  +
      Temp Read Blocks: N      +
      Temp Written Blocks: N   +
+     I/O Read Time: N.N       +
+     I/O Write Time: N.N      +
    Planning:                  +
      Shared Hit Blocks: N     +
      Shared Read Blocks: N    +
@@ -214,6 +224,8 @@
      Local Written Blocks: N  +
      Temp Read Blocks: N      +
      Temp Written Blocks: N   +
+     I/O Read Time: N.N       +
+     I/O Write Time: N.N      +
    Planning Time: N.N         +
    Triggers:                  +
    Execution Time: N.N
@@ -248,7 +260,9 @@
        "Local Dirtied Blocks": N,  +
        "Local Written Blocks": N,  +
        "Temp Read Blocks": N,      +
-       "Temp Written Blocks": N    +
+       "Temp Written Blocks": N,   +
+       "I/O Read Time": N.N,       +
+       "I/O Write Time": N.N       +
      },                            +
      "Planning": {                 +
        "Shared Hit Blocks": N,     +
@@ -260,7 +274,9 @@
        "Local Dirtied Blocks": N,  +
        "Local Written Blocks": N,  +
        "Temp Read Blocks": N,      +
-       "Temp Written Blocks": N    +
+       "Temp Written Blocks": N,   +
+       "I/O Read Time": N.N,       +
+       "I/O Write Time": N.N       +
      }                             +
    }                               +
  ]
@@ -348,7 +364,9 @@
                              "Actual Rows": 0,              +
                              "Actual Loops": 0,             +
                              "Startup Cost": 0.0,           +
+                             "I/O Read Time": 0.0,          +
                              "Relation Name": "tenk1",      +
+                             "I/O Write Time": 0.0,         +
                              "Parallel Aware": true,        +
                              "Local Hit Blocks": 0,         +
                              "Temp Read Blocks": 0,         +
@@ -393,6 +411,8 @@
                      "Actual Rows": 0,                      +
                      "Actual Loops": 0,                     +
                      "Startup Cost": 0.0,                   +
+                     "I/O Read Time": 0.0,                  +
+                     "I/O Write Time": 0.0,                 +
                      "Parallel Aware": false,               +
                      "Sort Space Used": 0,                  +
                      "Local Hit Blocks": 0,                 +
@@ -435,6 +455,8 @@
              "Actual Rows": 0,                              +
              "Actual Loops": 0,                             +
              "Startup Cost": 0.0,                           +
+             "I/O Read Time": 0.0,                          +
+             "I/O Write Time": 0.0,                         +
              "Parallel Aware": false,                       +
              "Workers Planned": 0,                          +
              "Local Hit Blocks": 0,                         +
@@ -452,6 +474,8 @@
              "Shared Written Blocks": 0                     +
          },                                                 +
          "Planning": {                                      +
+             "I/O Read Time": 0.0,                          +
+             "I/O Write Time": 0.0,                         +
              "Local Hit Blocks": 0,                         +
              "Temp Read Blocks": 0,                         +
              "Local Read Blocks": 0,                        +