test-crc.sh

application/x-shellscript

Download

set -e

xacts=30

for len in 32 64 96 128 160 192 224 256 8192
#for len in 48 64 80 96 112 128 144
do
	echo "$len"
	sql="select drive_crc32c(1000000, $len);"
	echo $sql > bench.sql

	for i in {1..3}
	do
		pgbench -n -t $xacts -f bench.sql | grep latency

		sleep 2
	done
done