[Info-ingres] Memory Utilisation 98%

[Laframboise, André (BAC/LAC)]

If it's a Linux box, 'free' memory can be misleading. The Linux OS uses as much free memory as possible as I/O buffers.
If will free up more memory if needed.

Check the actual memory size of the DBMS processes. If the server is a dedicated Ingres DB server, it would be normal for Ingres to use most of it.

André Laframboise

Conseiller Principal Base de Données, Direction générale de la gestion de l'information et Technologie de l'information
Bibliothèque et Archives Canada / Gouvernement du Canada
andre.laframboise at canada.ca / Tél. : 613-298-1346

Senior Database Advisor, Information Management and Information Technology Branch
Library and Archives Canada / Government of Canada
andre.laframboise at canada.ca / Tel: 613-298-1346
-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> On Behalf Of Steve
Sent: Wednesday, September 9, 2020 10:06 PM
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] Memory Utilisation 98%

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
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres