test-crc.sh
application/x-shellscript
Filename: test-crc.sh
Type: application/x-shellscript
Part: 0
set -e
xacts=30
for len in 64 80 96 112 128 144 160 176 192 208 224 240 256 8192
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