fsync-stress-v2.sh

application/x-sh

Filename: fsync-stress-v2.sh
Type: application/x-sh
Part: 1
Message: Count backend self-sync calls
#!/bin/bash
SCALE=100
if [ -n "$1" ] ; then
  SCALE="$1"
fi
dropdb pgbench
createdb pgbench
psql -d pgbench -c "select pg_stat_reset_shared('bgwriter')"
psql -d pgbench -x -c "select now(),* from pg_stat_bgwriter"
echo Initializing pgbench
pgbench -i -s $SCALE pgbench >> /dev/null 2>&1
psql -d pgbench -x -c "select now(),* from pg_stat_bgwriter"