fsync-stress-v2.sh
application/x-sh
#!/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"