PG-1013 Added build comparison table, moved features from index to comparison, created Beta2 release notes #157
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: Perf test | |
| on: [pull_request] | |
| permissions: | |
| contents: read | |
| jobs: | |
| build: | |
| runs-on: ubuntu-22.04 | |
| steps: | |
| - name: Remove old postgres | |
| run: | | |
| sudo apt purge postgresql-client-common postgresql-common \ | |
| postgresql postgresql* | |
| sudo rm -rf /var/lib/postgresql /var/log/postgresql /etc/postgresql \ | |
| /usr/lib/postgresql /usr/include/postgresql /usr/share/postgresql \ | |
| /etc/postgresql | |
| sudo rm -f /usr/bin/pg_config | |
| - name: Install dependencies | |
| run: | | |
| sudo apt-get update | |
| sudo apt-get install -y libreadline6-dev systemtap-sdt-dev \ | |
| zlib1g-dev libssl-dev libpam0g-dev bison flex \ | |
| libipc-run-perl -y docbook-xsl docbook-xsl libxml2 libxml2-utils \ | |
| libxml2-dev libxslt-dev xsltproc libkrb5-dev libldap2-dev \ | |
| libsystemd-dev gettext tcl-dev libperl-dev pkg-config clang-11 \ | |
| llvm-11 llvm-11-dev libselinux1-dev python3-dev \ | |
| uuid-dev liblz4-dev meson ninja-build \ | |
| sysbench libcurl4-openssl-dev libhttp-server-simple-perl python3-pykmip | |
| sudo /usr/bin/perl -MCPAN -e 'install IPC::Run' | |
| sudo /usr/bin/perl -MCPAN -e 'install Text::Trim' | |
| wget -O- https://apt.releases.hashicorp.com/gpg | sudo gpg --dearmor -o /usr/share/keyrings/hashicorp-archive-keyring.gpg | |
| echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/hashicorp-archive-keyring.gpg] https://apt.releases.hashicorp.com $(lsb_release -cs) main" | sudo tee /etc/apt/sources.list.d/hashicorp.list | |
| sudo apt update && sudo apt install -y vault | |
| - name: Clone postgres repository | |
| uses: actions/checkout@11bd71901bbe5b1630ceea73d27597364c9af683 # v4.2.2 | |
| with: | |
| repository: 'percona-lab/postgres' | |
| ref: 'TDE_REL_17_STABLE' | |
| path: 'src' | |
| - name: Clone pg_tde repository | |
| uses: actions/checkout@11bd71901bbe5b1630ceea73d27597364c9af683 # v4.2.2 | |
| with: | |
| path: 'src/contrib/pg_tde' | |
| - name: Checkout libkmip submodule | |
| run: | | |
| git submodule update --init --recursive | |
| working-directory: src/contrib/pg_tde | |
| - name: Build postgres | |
| run: | | |
| meson setup build --prefix `pwd`/../inst --buildtype=release | |
| cd build && ninja && ninja install | |
| working-directory: src | |
| - name: Setup kmip 1 | |
| run: | | |
| wget https://raw.githubusercontent.com/OpenKMIP/PyKMIP/refs/heads/master/bin/create_certificates.py | |
| python3 create_certificates.py | |
| cat client_certificate_jane_doe.pem >> client_key_jane_doe.pem | |
| working-directory: /tmp | |
| - name: Test pg_tde | |
| run: | | |
| TV=$(mktemp) | |
| { exec >$TV; vault server -dev; } & | |
| pykmip-server -f `pwd`/../contrib/pg_tde/pykmip-server.conf -l /tmp/kmip-server.log & | |
| sleep 10 | |
| export ROOT_TOKEN=$(cat $TV | grep "Root Token" | cut -d ":" -f 2 | xargs echo -n) | |
| echo "Root token: $ROOT_TOKEN" | |
| meson test --suite setup -v | |
| meson test --suite pg_tde -v --num-processes 1 | |
| working-directory: src/build | |
| - name: Report on test fail | |
| uses: actions/upload-artifact@b4b15b8c7c6ac21ea08fcf65892d2ee8f75cf882 # v4.4.3 | |
| if: ${{ failure() }} | |
| with: | |
| name: Regressions diff and postgresql log | |
| path: | | |
| src/build/testrun/pg_tde/regress/ | |
| retention-days: 3 | |
| - name: Setup test environment | |
| run: | | |
| bin/initdb -D data | |
| echo "shared_preload_libraries = 'pg_tde'" >> data/postgresql.conf | |
| bin/pg_ctl -D data start | |
| bin/createdb sbtest | |
| bin/createdb sbtest2 | |
| bin/createuser sbtest -s | |
| bin/psql sbtest2 <<< "CREATE EXTENSION pg_tde;" | |
| bin/psql sbtest2 <<< "SELECT pg_tde_add_key_provider_file('file-vault','/tmp/pg_tde_test_keyring.per');" | |
| bin/psql sbtest2 <<< "SELECT pg_tde_set_principal_key('test-db-principal-key','file-vault');" | |
| cp -r ../src/contrib/pg_tde/sysbench . | |
| cp -r ../src/contrib/pg_tde/perf . | |
| working-directory: inst | |
| - name: Run baseline performance tests | |
| run: | | |
| sysbench --db-driver=pgsql --threads=1 sysbench/oltp_insert.lua --tables=1 --table-size=10000 --pgsql-db=sbtest prepare | |
| sysbench --db-driver=pgsql --threads=1 sysbench/oltp_read_only.lua --tables=1 --table-size=10000 --pgsql-db=sbtest run | |
| sysbench --db-driver=pgsql --threads=1 sysbench/oltp_read_only.lua --tables=1 --table-size=10000 --pgsql-db=sbtest run | tee perf_norm | |
| working-directory: inst | |
| - name: Run TDE performance tests | |
| run: | | |
| sysbench --db-driver=pgsql --threads=1 sysbench/oltp_common_tde.lua --tables=1 --table-size=10000 --pgsql-db=sbtest2 prepare | |
| sysbench --db-driver=pgsql --threads=1 sysbench/oltp_read_only.lua --tables=1 --table-size=10000 --pgsql-db=sbtest2 run | |
| sysbench --db-driver=pgsql --threads=1 sysbench/oltp_read_only.lua --tables=1 --table-size=10000 --pgsql-db=sbtest2 run | tee perf_tde | |
| working-directory: inst | |
| - name: Run seq read performance tests | |
| run: | | |
| export PATH=../bin/:$PATH | |
| ./seq_read.sh | tee seq_read | |
| working-directory: inst/perf | |
| - name: Print results | |
| run: | | |
| NORM_Q=$(cat perf_norm | grep 'total number of events' | cut -d ':' -f 2 | sed 's/ //g') | |
| TDE_Q=$(cat perf_tde | grep 'total number of events' | cut -d ':' -f 2 | sed 's/ //g') | |
| echo "Norm queries: $NORM_Q" | |
| echo "TDE queries: $TDE_Q" | |
| echo "Performance test results:" >> pr_perf_results | |
| echo "Normal queries: $(cat perf_norm | grep 'total number of events' | cut -d ':' -f 2 | sed 's/ //g')" >> pr_perf_results | |
| echo "TDE queries: $(cat perf_tde | grep 'total number of events' | cut -d ':' -f 2 | sed 's/ //g')" >> pr_perf_results | |
| echo "Percentage: $(($TDE_Q*100/$NORM_Q))%" >> pr_perf_results | |
| cat perf/seq_read >> pr_perf_results | |
| PERF_RESULT=$(cat pr_perf_results) | |
| echo "PERF_RESULT<<EOF" >> $GITHUB_ENV | |
| echo "$PERF_RESULT" >> $GITHUB_ENV | |
| echo "EOF" >> $GITHUB_ENV | |
| working-directory: inst | |
| - uses: actions/upload-artifact@b4b15b8c7c6ac21ea08fcf65892d2ee8f75cf882 # v4.4.3 | |
| with: | |
| name: pr_perf_results | |
| path: inst/pr_perf_results |