skip to Main Content

We have a Data ware house server running on Debian linux ,We are using PostgreSQL , Jenkins and Python.

It’s been few day the memory of the CPU is consuming a lot by jenkins and Postgres.tried to find and check all the ways from google but the issue is still there.

Anyone can give me a lead on how to reduce this memory consumption,It will be very helpful.

below is the output from free -m

              total        used        free      shared  buff/cache   available
Mem:          63805        9152         429       16780       54223       37166
Swap:             0           0           0

below is the postgresql.conf file
enter image description here
Below is the System configurations,

enter image description here

Results from htop
enter image description here

2

Answers


  1. For Jenkins, run it with these JAVA Options

    JAVA_OPTS=-Xms200m -Xmx300m -XX:PermSize=68m -XX:MaxPermSize=100m
    

    For postgres, start it with option

    -c shared_buffers=256MB
    

    These values are the one I use on a small homelab of 8GB memory, you might want to increase these to match your hardware

    Login or Signup to reply.
  2. Please don’t post text as images. It is hard to read and process.

    I don’t see your problem.

    Your machine has 64 GB RAM, 16 GB are used for PostgreSQL shared memory like you configured, 9 GB are private memory used by processes, and 37 GB are free (the available entry).

    Linux uses available memory for the file system cache, which boosts PostgreSQL performance. The low value for free just means that the cache is in use.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search