2 ms·

Why doesn't Postgres autotune those settings? Determining this experimentally seems to be very fragile

• drewcoo 2y ago
  There is a certain appeal for Javaheads. java -Xms$FOO -Xmx$BAR I've worked on things where we had to know the correct heap incantation to run a service.
  • tempest_ 2y ago
    The exact settings for those params is always more
    • Izkata 2y ago
      With a caveat: If you cross 32G heap size, the JVM will start using more and you effectively have less memory available until you get to 48G. https://confluence.atlassian.com/jirakb/do-not-use-heap-sizes-between-32-gb-and-47-gb-in-jira-compressed-oops-1167745277.html https://confluence.atlassian.com/jirakb/do-not-use-heap-size... We had this problem for a while in one of our (non-Atlassian) systems and were running it with Xmx at 31.5G
      • tempest_ 2y ago
        So what your saying is your problem would have been solved if you just increased the number...