Add index creation on orderby columns #2089
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: pg_upgrade test | |
| "on": | |
| push: | |
| branches: | |
| - main | |
| - prerelease_test | |
| pull_request: | |
| jobs: | |
| pg_upgrade_test: | |
| name: pg_upgrade test from PG${{ matrix.pg_version_old }} to PG${{ matrix.pg_version_new }} | |
| runs-on: 'ubuntu-latest' | |
| strategy: | |
| matrix: | |
| include: | |
| - pg_version_old: 14 # 14 to 15 | |
| pg_version_new: 15 | |
| - pg_version_old: 14 # 14 to 16 | |
| pg_version_new: 16 | |
| - pg_version_old: 15 # 15 to 16 | |
| pg_version_new: 16 | |
| - pg_version_old: 14 # 14 to 17 | |
| pg_version_new: 17 | |
| - pg_version_old: 15 # 15 to 17 | |
| pg_version_new: 17 | |
| - pg_version_old: 16 # 16 to 17 | |
| pg_version_new: 17 | |
| fail-fast: false | |
| env: | |
| OUTPUT_DIR: ${{ github.workspace }}/pg_upgrade_test | |
| steps: | |
| - name: Install Linux Dependencies | |
| run: | | |
| sudo apt-get update | |
| sudo apt-get install pip postgresql-common libkrb5-dev | |
| - name: Install testgres | |
| run: | | |
| pip install testgres | |
| - name: Install PostgreSQL ${{ matrix.pg_version_old}} and ${{ matrix.pg_version_new }} | |
| run: | | |
| yes | sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh | |
| echo "deb https://packagecloud.io/timescale/timescaledb/ubuntu/ $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/timescaledb.list | |
| wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add - | |
| sudo apt-get update | |
| sudo apt-get install -y \ | |
| postgresql-${{ matrix.pg_version_old }} postgresql-server-dev-${{ matrix.pg_version_old }} \ | |
| postgresql-${{ matrix.pg_version_new }} postgresql-server-dev-${{ matrix.pg_version_new }} | |
| sudo apt-get install -y --no-install-recommends \ | |
| timescaledb-2-postgresql-${{ matrix.pg_version_old }} \ | |
| timescaledb-2-postgresql-${{ matrix.pg_version_new }} | |
| - name: Checkout TimescaleDB | |
| uses: actions/checkout@v4 | |
| - name: Build and install TimescaleDB on PostgreSQL ${{ matrix.pg_version_old}} | |
| env: | |
| BUILD_DIR: pg${{ matrix.pg_version_old }} | |
| run: | | |
| PATH="/usr/lib/postgresql/${{ matrix.pg_version_old }}/bin:$PATH" | |
| ./bootstrap -DCMAKE_BUILD_TYPE=Release -DWARNINGS_AS_ERRORS=OFF -DASSERTIONS=ON -DLINTER=OFF -DGENERATE_DOWNGRADE_SCRIPT=OFF -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF | |
| make -j -C pg${{ matrix.pg_version_old }} | |
| sudo make -j -C pg${{ matrix.pg_version_old }} install | |
| - name: Build and install TimescaleDB on PostgreSQL ${{ matrix.pg_version_new}} | |
| env: | |
| BUILD_DIR: pg${{ matrix.pg_version_new }} | |
| run: | | |
| PATH="/usr/lib/postgresql/${{ matrix.pg_version_new }}/bin:$PATH" | |
| ./bootstrap -DCMAKE_BUILD_TYPE=Release -DWARNINGS_AS_ERRORS=OFF -DASSERTIONS=ON -DLINTER=OFF -DGENERATE_DOWNGRADE_SCRIPT=OFF -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF | |
| make -j -C pg${{ matrix.pg_version_new }} | |
| sudo make -j -C pg${{ matrix.pg_version_new }} install | |
| - name: Run pg_upgrade test | |
| env: | |
| PGVERSIONOLD: ${{ matrix.pg_version_old }} | |
| PGVERSIONNEW: ${{ matrix.pg_version_new }} | |
| DIFFFILE: ${{ env.OUTPUT_DIR }}/upgrade_check.diff | |
| run: | | |
| scripts/test_pg_upgrade.py | |
| diff -u \ | |
| "${OUTPUT_DIR}/post.pg${PGVERSIONOLD}.log" \ | |
| "${OUTPUT_DIR}/post.pg${PGVERSIONNEW}.log" | \ | |
| tee "${DIFFFILE}" | |
| if [[ -s "${DIFFFILE}" ]]; then | |
| echo "pg_upgrade test for ${PGVERSIONOLD} -> ${PGVERSIONNEW} failed" | |
| exit 1 | |
| fi | |
| - name: Show pg_upgrade diffs | |
| if: always() | |
| env: | |
| DIFFFILE: ${{ env.OUTPUT_DIR }}/upgrade_check.diff | |
| DIROLD: pg${{ matrix.pg_version_old }} | |
| DIRNEW: pg${{ matrix.pg_version_new }} | |
| run: | | |
| cd ${OUTPUT_DIR} | |
| cat ${DIFFFILE} | |
| tar czf /tmp/pg_upgrade_artifacts.tgz \ | |
| ${DIFFFILE} \ | |
| ${OUTPUT_DIR}/*.log \ | |
| ${OUTPUT_DIR}/${DIROLD}/logs/* \ | |
| ${OUTPUT_DIR}/${DIRNEW}/logs/* \ | |
| ${OUTPUT_DIR}/${DIRNEW}/data/pg_upgrade_output.d/* | |
| - name: Upload pg_upgrade logs | |
| if: always() | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: pg_upgrade logs from ${{ matrix.pg_version_old }} to ${{ matrix.pg_version_new }} | |
| path: /tmp/pg_upgrade_artifacts.tgz |