Search code examples
postgresqltimescaledb

dbeaver and other connections somehow consumes postgresql server memory

I am mostly using DBeaver and psycopg2 and sqlalchemy to connect to my postgresql timescaleDB instance. As I run more and more query, when i perform htop. I realized postgresql is occupying more and more memory.... Is there a way for me to release this memory? Thanksenter image description here

Edit: my 2nd replication of the problem. https://i.sstatic.net/hANEh.png

enter image description here

enter image description here

Solution

  • From the VIRT column, it looks like your shared_buffers is set to 15GB. That is a curiously large setting to be used by someone concerned about memory usage.

    Other than that, there is no indication of a problem here. None of them is using anywhere near the memory you have given them permission to use; and most of that is shared between them. Meaning you should only count it once, not once per process.