matheusoliveira · April 1, 2014 14:34
diff --git a/parallel_vacuum.sh b/parallel_vacuum.sh
 #!/bin/sh

 JOBS=8
 export PGDATABASE=<your database name>

 psql -A0Xtc "SELECT oid::regclass::text FROM pg_class WHERE relkind IN ('r','m')" | xargs -P $JOBS -0 -I {} bash -c 'echo "`date`: started {}"; vacuumdb --analyze --table={} && echo "`date`: {}: OK" || echo "`date`: {}: FAILED!"'
	#!/bin/sh

	JOBS=8
	export PGDATABASE=<your database name>

	psql -A0Xtc "SELECT oid::regclass::text FROM pg_class WHERE relkind IN ('r','m')" \| xargs -P $JOBS -0 -I {} bash -c 'echo "`date`: started {}"; vacuumdb --analyze --table={} && echo "`date`: {}: OK" \|\| echo "`date`: {}: FAILED!"'