1. Forum
  2. USENET
  3. comp.databases.ingres

  • Memory Utilisation 98%

    From Steve@s.anderson.au@gmail.com to comp.databases.ingres on Wed Sep 9 19:06:27 2020
    From Newsgroup: comp.databases.ingres

    Hi there

    Memory utilisation in our production box gets as high as 98% each day. With Ingres occupying most of the memory, I would like to reduce how much it uses. Am I right in thinking Ingres pre-allocates all the memory it requires at startup?

    Previously, Actian had recommended reducing the QSF pool size, as its utilisation was low. So I guess that's an obvious candidate to recover some memory.

    Where should one start when wanting to reduce the amount of memory Ingres uses? I would like to reduce the installation's memory footprint by 5%.

    Thanks
    Steve
    --- Synchronet 3.21d-Linux NewsLink 1.2