: . traprm export QUIET=$((QUIET + 1)) > /rtmp/out export PGOPTIONS="-c synchronous_commit=off" for CYCLES in 1 1000 2000 4000 8000 16000 32000 64000 do echo "$CYCLES" >> /rtmp/out for BRANCH in master no-single do cd /pgtop pgsw $BRANCH cd - /pg_upgrade/tools/setup 9.3 9.3 sleep 2 # need for +16k for CONFIG in /u/pgsql.old/data/postgresql.conf /u/pgsql/data/postgresql.conf do pipe sed 's/#max_locks_per_transaction = 64/max_locks_per_transaction = 64000/' "$CONFIG" pipe sed 's/shared_buffers = 128MB/shared_buffers = 1GB/' "$CONFIG" done pgstart /u/pgsql.old/data sleep 8 for JOT in $(jot "$CYCLES"); do echo "CREATE TABLE test$JOT (x SERIAL PRIMARY KEY);"; done| sql test pgstop /u/pgsql.old/data sleep 2 /usr/bin/time --output=/rtmp/out --append --format '%e' /pg_upgrade/tools/upgrade sleep 2 done done bell