On Fri, Jul 11, 2025 at 3:48 PM Greg Burd <g...@burd.me> wrote: > I briefly considered how one might use what was left after surgery to produce > some similar boolean signal to no avail. I think that autoprewarm was simply > trying to at most warm NBuffers then stop. The freelist at startup was just > a convenient thing to drain and get that done. Maybe I'll try adapting > autoprewarm to consider that global instead.
My concern had been that while autoprewarm was running, other system activity could already have started and been filling up shared_buffers. By considering whether there were actually free buffers remaining, it would prewarm less in that case. I'm not saying that was the perfect idea, I'm just telling you what I was thinking at the time. -- Robert Haas EDB: http://www.enterprisedb.com
