Re: Protect syscache from bloating with negative cache entries

[Kyotaro HORIGUCHI]

Oops.

At Mon, 12 Mar 2018 17:34:08 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI 
<horiguchi.kyot...@lab.ntt.co.jp> wrote in 
<20180312.173408.162882093.horiguchi.kyot...@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);
}