pg waldump improvements

1. add neon resource manager in waldump 2. print end lsn Only applies starting at Postgres 16, before that the pg_waldump and custom WAL Resource Managers are not ready.
2026-05-20 06:30:43 +00:00 · 2025-08-01 16:31:18 +02:00
6 changed files with 9 additions and 39 deletions
--- a/.github/workflows/_benchmarking_preparation.yml
+++ b/.github/workflows/_benchmarking_preparation.yml
@@ -20,7 +20,7 @@ jobs:
    strategy:
      fail-fast: false
      matrix:
-        platform: [ aws-rds-postgres, aws-aurora-serverless-v2-postgres, neon, neon_pg17, neon_pg18 ]
+        platform: [ aws-rds-postgres, aws-aurora-serverless-v2-postgres, neon, neon_pg17 ]
        database: [ clickbench, tpch, userexample ]

    env:
@@ -52,9 +52,6 @@ jobs:
          neon_pg17)
            CONNSTR=${{ secrets.BENCHMARK_CAPTEST_CONNSTR_PG17 }}
            ;;
-          neon_pg18)
-            CONNSTR=${{ secrets.BENCHMARK_CAPTEST_CONNSTR_PG18 }}
-            ;;
          aws-rds-postgres)
            CONNSTR=${{ secrets.BENCHMARK_RDS_POSTGRES_CONNSTR }}
            ;;
--- a/.github/workflows/benchmarking.yml
+++ b/.github/workflows/benchmarking.yml
@@ -142,10 +142,6 @@ jobs:
            PLATFORM: "neon-staging"
            region_id: ${{ github.event.inputs.region_id || 'aws-us-east-2' }}
            RUNNER: [ self-hosted, us-east-2, x64 ]
-          - PG_VERSION: 18
-            PLATFORM: "neon-staging"
-            region_id: ${{ github.event.inputs.region_id || 'aws-us-east-2' }}
-            RUNNER: [ self-hosted, us-east-2, x64 ]
          - PG_VERSION: 16
            PLATFORM: "azure-staging"
            region_id: 'azure-eastus2'
@@ -263,7 +259,7 @@ jobs:
      id-token: write # aws-actions/configure-aws-credentials
    env:
      POSTGRES_DISTRIB_DIR: /tmp/neon/pg_install
-      DEFAULT_PG_VERSION: 18
+      DEFAULT_PG_VERSION: 17
      TEST_OUTPUT: /tmp/test_output
      BUILD_TYPE: remote
      SAVE_PERF_REPORT: ${{ github.event.inputs.save_perf_report || ( github.ref_name == 'main' ) }}
@@ -546,11 +542,7 @@ jobs:
                      { "pg_version": 17, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-freetier",       "db_size": "3gb" ,"runner": '"$runner_default"', "image": "'"$image_default"'"                               },
                      { "pg_version": 17, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-new",            "db_size": "10gb","runner": '"$runner_default"', "image": "'"$image_default"'"                               },
                      { "pg_version": 17, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-new-many-tables","db_size": "10gb","runner": '"$runner_default"', "image": "'"$image_default"'"                               },
-                      { "pg_version": 17, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-new",            "db_size": "50gb","runner": '"$runner_default"', "image": "'"$image_default"'"                               },
-                      { "pg_version": 18, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-freetier",       "db_size": "3gb" ,"runner": '"$runner_default"', "image": "'"$image_default"'"                               },
-                      { "pg_version": 18, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-new",            "db_size": "10gb","runner": '"$runner_default"', "image": "'"$image_default"'"                               },
-                      { "pg_version": 18, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-new-many-tables","db_size": "10gb","runner": '"$runner_default"', "image": "'"$image_default"'"                               },
-                      { "pg_version": 18, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-new",            "db_size": "50gb","runner": '"$runner_default"', "image": "'"$image_default"'"                               }]
+                      { "pg_version": 17, "region_id": "'"$region_id_default"'", "platform": "neonvm-captest-new",            "db_size": "50gb","runner": '"$runner_default"', "image": "'"$image_default"'"                               }]
        }'

        if [ "$(date +%A)" = "Saturday" ] || [ ${RUN_AWS_RDS_AND_AURORA} = "true" ]; then
@@ -568,7 +560,7 @@ jobs:
            "neonvm-captest-reuse"
          ],
          "pg_version" : [
-            16,17,18
+            16,17
          ]
        }'

@@ -587,7 +579,7 @@ jobs:
            "neonvm-captest-reuse"
          ],
          "pg_version" : [
-            16,17,18
+            16,17
          ]
        }'

@@ -801,9 +793,6 @@ jobs:
          - PLATFORM: "neonvm-captest-pgvector-pg17"
            RUNNER: [ self-hosted, us-east-2, x64 ]
            postgres_version: 17
-          - PLATFORM: "neonvm-captest-pgvector-pg18"
-            RUNNER: [ self-hosted, us-east-2, x64 ]
-            postgres_version: 18
          - PLATFORM: "azure-captest-pgvector"
            RUNNER: [ self-hosted, eastus2, x64 ]
            postgres_version: 16
@@ -860,9 +849,6 @@ jobs:
          neonvm-captest-pgvector-pg17)
            CONNSTR=${{ secrets.BENCHMARK_PGVECTOR_CONNSTR_PG17 }}
            ;;
-          neonvm-captest-pgvector-pg18)
-            CONNSTR=${{ secrets.BENCHMARK_PGVECTOR_CONNSTR_PG18 }}
-            ;;
          azure-captest-pgvector)
            CONNSTR=${{ secrets.BENCHMARK_PGVECTOR_CONNSTR_AZURE }}
            ;;
@@ -999,9 +985,6 @@ jobs:
              17)
                CONNSTR=${{ secrets.BENCHMARK_CAPTEST_CLICKBENCH_CONNSTR_PG17 }}
                ;;
-              18)
-                CONNSTR=${{ secrets.BENCHMARK_CAPTEST_CLICKBENCH_CONNSTR_PG18 }}
-                ;;
              *)
                echo >&2 "Unsupported PG_VERSION=${PG_VERSION} for PLATFORM=${PLATFORM}"
                exit 1
@@ -1127,9 +1110,6 @@ jobs:
              17)
                CONNSTR_SECRET_NAME="BENCHMARK_CAPTEST_TPCH_CONNSTR_PG17"
                ;;
-              18)
-                CONNSTR_SECRET_NAME="BENCHMARK_CAPTEST_TPCH_CONNSTR_PG18"
-                ;;
              *)
                echo >&2 "Unsupported PG_VERSION=${PG_VERSION} for PLATFORM=${PLATFORM}"
                exit 1
@@ -1255,9 +1235,6 @@ jobs:
              17)
                CONNSTR=${{ secrets.BENCHMARK_CAPTEST_USER_EXAMPLE_CONNSTR_PG17 }}
                ;;
-              18)
-                CONNSTR=${{ secrets.BENCHMARK_CAPTEST_USER_EXAMPLE_CONNSTR_PG18 }}
-                ;;
              *)
                echo >&2 "Unsupported PG_VERSION=${PG_VERSION} for PLATFORM=${PLATFORM}"
                exit 1
--- a/.github/workflows/ingest_benchmark.yml
+++ b/.github/workflows/ingest_benchmark.yml
@@ -49,10 +49,6 @@ jobs:
            stripe_size: null # run with neon defaults which will shard split only when reaching the threshold
            disable_sharding: false
            postgres_version: 17
-          - target_project: new_empty_project
-            stripe_size: null # run with neon defaults which will shard split only when reaching the threshold
-            disable_sharding: false
-            postgres_version: 18
          - target_project: large_existing_project
            stripe_size: null # cannot re-shared or choose different stripe size for existing, already sharded project
            disable_sharding: false
--- a/vendor/postgres-v16
+++ b/vendor/postgres-v16
--- a/vendor/postgres-v17
+++ b/vendor/postgres-v17
--- a/vendor/revisions.json
+++ b/vendor/revisions.json
@@ -1,11 +1,11 @@
 {
  "v17": [
    "17.5",
-    "1e01fcea2a6b38180021aa83e0051d95286d9096"
+    "689f8b9978b7b1600bbd8501578c02f11152816e"
  ],
  "v16": [
    "16.9",
-    "a42351fcd41ea01edede1daed65f651e838988fc"
+    "78312c82f9061138cedcd8f935df24f00935ef55"
  ],
  "v15": [
    "15.13",