#! /usr/bin/perl

print "set track_syscache_usage_interval to 1000;\n";

## for time-based pruning
#print "set cache_prune_min_age to '5s';\n";
#print "set cache_memory_target to '0';\n";

## for limit-based pruning
print "set cache_memory_target to '100MB';\n";
print "set cache_entry_limit to 10000;\n";
print "set cache_entry_limit_prune_ratio to 0.6;\n";

while (1) {
	print "begin; create temp table t1 (a int, b int, c int, d int, e int, f int, g int, h int, i int, j int) on commit drop; insert into t1 values (1, 2, 3, 4, 5, 6, 7, 8, 9, 10); select * from t1; commit;\n";
}