Hi, I have set join_collapse_limit = 12 in production, but I'm thinking about
raising it to 16.
On modern HW is there a “sane maximum” for this value?
I can easily spare 10ms for extra planning per query on our workload, is 16
too high?
Thanks.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>