measure_pub.sh

application/x-sh

Filename: measure_pub.sh

Type: application/x-sh

Part: 1

Message: Re: Conflict detection for update_deleted in logical replication

#!/bin/bash

##################
### Definition ###
##################
## posrts
port_pub=5433
port_sub=5434

## Used source (change it as per code source)
SOURCE=head

## Number of runs
NUMRUN=10

## Measurement duration
DURATION=120

## Number of clients during a run
NUMCLIENTS=60

###########################
### measure performance ###
###########################

for i in `seq ${NUMRUN}`
do
    # Prepare clean enviroment for each measurements
    sh setup_pub.sh $SOURCE

    echo "=================="
    echo "${SOURCE}_${i}.dat"
    echo "=================="

    # Do actual measurements                                                                                        
    ./pgbench postgres -p $port_pub -c $NUMCLIENTS -j $NUMCLIENTS -T $DURATION  > "${SOURCE}_${i}.dat"

done