On Fri, Jul 10, 2020 at 2:10 PM Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > I'm not sure about this bit; sounds a bit like what has been qualified > as "nannyism" elsewhere. Suppose I want to give a hash table 2GB of > memory for whatever reason. If my work_mem is default (4MB) then I > cannot possibly achieve that without altering both settings. > > So I propose that maybe we do want a maximum value, but if so it should > be higher than what you propose. I think 10000 is acceptable in that it > doesn't get in the way.
That's a good point. I amend my proposal: the maximum allowable value of hash_mem_multiplier should be 10000.0 (i.e., ten thousand times whatever work_mem is set to, which is subject to the existing work_mem sizing restrictions). -- Peter Geoghegan
