increase insert xxx select xxx speed #107
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: polardb-regression-testing | |
on: | |
push: | |
branches: [ POLARDB_11_DEV, POLARDB_11_STABLE ] | |
paths: | |
- '.github/workflows/regression-test.yml' | |
- 'config/**' | |
- 'contrib/**' | |
- 'external/**' | |
- 'src/**' | |
- 'configure*' | |
- 'polardb_build.sh' | |
pull_request: | |
branches: [ POLARDB_11_DEV, POLARDB_11_STABLE ] | |
paths: | |
- '.github/workflows/regression-test.yml' | |
- 'config/**' | |
- 'contrib/**' | |
- 'external/**' | |
- 'src/**' | |
- 'configure*' | |
- 'polardb_build.sh' | |
# trigger testing manually | |
workflow_dispatch: | |
jobs: | |
build: | |
runs-on: ubuntu-latest | |
strategy: | |
matrix: | |
container_image: [ centos7 ] | |
instance_type: [ oltp, htap, dma ] | |
steps: | |
- | |
name: Fetch PolarDB source code | |
uses: actions/checkout@v3 | |
- | |
name: Create and start the container | |
run: | | |
docker create \ | |
-t \ | |
--name polardb_${{ matrix.container_image }} \ | |
-v `pwd`:/home/postgres/PolarDB-for-PostgreSQL \ | |
polardb/polardb_pg_devel:${{ matrix.container_image }} \ | |
bash && \ | |
docker start polardb_${{ matrix.container_image }} | |
- | |
name: Change ownership of the source code | |
run: | | |
docker exec \ | |
polardb_${{ matrix.container_image }} \ | |
bash -c "cd /home/postgres/PolarDB-for-PostgreSQL && \ | |
sudo chown -R postgres:postgres ./" | |
- | |
name: Ignore some test cases for OLTP regression testing | |
if: ${{ matrix.instance_type == 'oltp' }} | |
run: | | |
docker exec \ | |
polardb_${{ matrix.container_image }} \ | |
bash -c "cd /home/postgres/PolarDB-for-PostgreSQL" | |
- | |
name: Build and run OLTP regression testing | |
if: ${{ matrix.instance_type == 'oltp' }} | |
run: | | |
docker exec \ | |
polardb_${{ matrix.container_image }} \ | |
bash -c "cd /home/postgres/PolarDB-for-PostgreSQL && \ | |
source /etc/bashrc && \ | |
./polardb_build.sh --withrep -r -e -r-external \ | |
-r-contrib -r-pl --with-tde" | |
- | |
name: Ignore some test cases for HTAP regression testing | |
if: ${{ matrix.instance_type == 'htap' }} | |
run: | | |
docker exec \ | |
polardb_${{ matrix.container_image }} \ | |
bash -c "cd /home/postgres/PolarDB-for-PostgreSQL && \ | |
sed -i 's/test: polar-px-dev\/polar_partition_huge/#&/g' src/test/regress/polar-px-dev-schedule" | |
- | |
name: Build and run HTAP regression testing | |
if: ${{ matrix.instance_type == 'htap' }} | |
run: | | |
docker exec \ | |
polardb_${{ matrix.container_image }} \ | |
bash -c "cd /home/postgres/PolarDB-for-PostgreSQL && \ | |
source /etc/bashrc && \ | |
./polardb_build.sh -r-px -e -r-external \ | |
-r-contrib -r-pl --with-tde" | |
- | |
name: Build and run DMA regression testing | |
if: ${{ matrix.instance_type == 'dma' }} | |
run: | | |
docker exec \ | |
polardb_${{ matrix.container_image }} \ | |
bash -c "cd /home/postgres/PolarDB-for-PostgreSQL && \ | |
source /etc/bashrc && \ | |
./polardb_build.sh -r -e -r-external \ | |
-r-contrib -r-pl --with-tde --with-dma" | |
- name: Change ownership of the source code | |
run: | | |
sudo chown -R runner:runner `pwd` |