vacuum_cached.sh

application/x-shellscript

Filename: vacuum_cached.sh

Type: application/x-shellscript

Part: 2

Message: Re: Use streaming read I/O in BRIN vacuuming

#!/usr/bin/env sh

PG_INSTALL_BIN='../install/bin'
PG_DATA='../data'
PG_CONF='../data/postgresql.conf'

echo cached
echo
$PG_INSTALL_BIN/psql -h localhost -p 5433 -d postgres -c 'set enable_seqscan = off; select count(*) from t1;'
$PG_INSTALL_BIN/psql -h localhost -p 5433 -d postgres -c 'vacuum (VERBOSE) t1'