test_many_tables

:

. traprm

export QUIET=$((QUIET + 1))

> /rtmp/out

for CYCLES in 1 1000 2000 4000 8000 16000
do
	echo "$CYCLES" >> /rtmp/out

	for DIR in /pgtoprel /pgtop
	do	echo "$DIR" >> /rtmp/out
		cd "$DIR"
		pginstall

		# need for +16k
		pipe sed 's/#max_locks_per_transaction = 64/max_locks_per_transaction = 500/' /u/pg/data/postgresql.conf
		pgrestart
		sleep 2

		for JOT in $(jot "$CYCLES"); do echo "CREATE TABLE test$JOT (x SERIAL);"; done| PGOPTIONS="-c synchronous_commit=off" sql test
		echo "pg_dump creation" >> /rtmp/out
		/usr/bin/time --output=/rtmp/out --append --format '%e' aspg pg_dump test > $TMP/1
		newdb test
		echo "pg_dump restore" >> /rtmp/out
		PGOPTIONS="-c synchronous_commit=off" /usr/bin/time --output=/rtmp/out --append --format '%e' sql test < $TMP/1
		pgstop
		sleep 2
	done
	
	tools/setup
	sleep 2

	# need for +16k
	pipe sed 's/#max_locks_per_transaction = 64/max_locks_per_transaction = 500/' /u/pgsql.old/data/postgresql.conf

	pgstart /u/pgsql.old/data
	sleep 2
	for JOT in $(jot "$CYCLES"); do echo "CREATE TABLE test$JOT (x SERIAL);"; done| PGOPTIONS="-c synchronous_commit=off" sql test
	pgstop /u/pgsql.old/data
	sleep 2
	/usr/bin/time --output=/rtmp/out --append --format '%e' tools/upgrade
done

bell