Oops.
At Mon, 12 Mar 2018 17:34:08 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> wrote in
<20180312.173408.162882093.horiguchi.kyotaro@lab.ntt.co.jp>
> Something like the sttached test script causes relcache
This is that.
#! /usr/bin/perl
# printf("drop schema if exists test_schema;\n", $i);
printf("create schema test_schema;\n", $i);
printf("create table test_schema.t%06d ();\n", $i);
for $i (0..100000) {
printf("create table test_schema.t%06d ();\n", $i);
}
printf("set syscache_memory_target = \'1kB\';\n");
printf("set syscache_prune_min_age = \'15s\';\n");
for $i (0..100000) {
printf("select * from test_schema.t%06d;\n", $i);
}