On Fri, Feb 15, 2019 at 3:30 PM Tomas Vondra <tomas.von...@2ndquadrant.com> wrote: > That TPS chart looks a bit ... wild. How come the master jumps so much > up and down? That's a bit suspicious, IMHO.
Somebody should write a patch to make buffer eviction completely random, without aiming to get it committed. That isn't as bad of a strategy as it sounds, and it would help with assessing improvements in this area. We know that the cache replacement algorithm behaves randomly when there is extreme contention, while also slowing everything down due to maintaining the clock. A unambiguously better caching algorithm would at a minimum be able to beat our "cheap random replacement" prototype as well as the existing clocksweep algorithm in most or all cases. That seems like a reasonably good starting point, at least. -- Peter Geoghegan
