freelist会减少对io及buffer的需求吗？

freelist会减少对io及buffer的需求吗？

现在有一个数据库，类似于数据仓库，很大，TB级，只有几个表，每个表有一个或者几个session在向里面插入数据。没有别的操作，比如update、delete等dml操作，平均每天插入的数据量在1亿条

我现在的理解，如果使用freelist，那是不是在buffer cache中，会有比较少的dirty block呢？因为插入操作所获得的块只能从freelist中获得

而如果使用assm，是不是在buffer cache中，会有比较多的dirty block呢？

因为dirty block多，所以造成物理io比较多，如果使用freelist的话，是不是就会有比较少的物理io，也会减少free buffer wait这样的事件呢？

增加freelist或者使用assm是不是适用于many concurrency的环境，对于我这样的环境，是不是使用freelist相反会更好一些呢？

weibo.com/ttarticle/p/show?id=2309405163630776942742

weibo.com/ttarticle/p/show?id=2309405163629287964927

weibo.com/ttarticle/p/show?id=2309405163629333839964

weibo.com/ttarticle/p/show?id=2309405163629489291323

weibo.com/ttarticle/p/show?id=2309405163629640286343

weibo.com/ttarticle/p/show?id=2309405163629975830672

weibo.com/ttarticle/p/show?id=2309405163630143340612

weibo.com/ttarticle/p/show?id=2309405163630474952804

weibo.com/ttarticle/p/show?id=2309405163630625947665

weibo.com/ttarticle/p/show?id=2309405163631762604128

weibo.com/ttarticle/p/show?id=2309405163631972057183

weibo.com/ttarticle/p/show?id=2309405163637840150656

weibo.com/ttarticle/p/show?id=2309405163638041215010

weibo.com/ttarticle/p/show?id=2309405163640734220439

weibo.com/ttarticle/p/show?id=2309405163641073959002

weibo.com/ttarticle/p/show?id=2309405163633088004227

weibo.com/ttarticle/p/show?id=2309405163633570349095

weibo.com/ttarticle/p/show?id=2309405163634690228235

weibo.com/ttarticle/p/show?id=2309405163634958663934

weibo.com/ttarticle/p/show?id=2309405163641992249437

weibo.com/ttarticle/p/show?id=2309405163642025803883

weibo.com/ttarticle/p/show?id=2309405163643762245730

weibo.com/ttarticle/p/show?id=2309405163644433334299

weibo.com/ttarticle/p/show?id=2309405163645259612317

weibo.com/ttarticle/p/show?id=2309405163645461201161