Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database. - Mailing list pgsql-bugs
From
Zaid Shabbir
Subject
Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.
I reviewed your attached postgresql.conf file and observed some concerning points. As you mentioned you have 256 GB RAM with 100 GB database size. In your configuration file you use higher ranges as compared to your system resources like ..
shared_buffers = 120000MB
...
work_mem = 2048MB
...
maintenance_work_mem = 2048MB
...
effective_cache_size = 120000MB
...
max_connection = 3000
The above configuration looks too much as per your available system resources. It looks like you need some expert review to evaluate your system resources and configure the server accordingly.
Thanks & Regards
Zaid
Bitnine Global Inc.
On Thu, Jul 25, 2024 at 5:01 PM Mohammed Siddiqui <msiddiqui@net32.com> wrote:
> We have been seeing intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of free RAM. We have a 100 GB database with 256 GB RAM on the server so there is no shortage of RAM nor shortage in PostgreSQL buffer cache. Our swappiness setting is set to “1”. > [...]
Please provide your postgresql.conf.
Also, why do you need a swap on such a setup? I seriously doubt that it serves any purpose.
From:
Muhammad Waqas Date: Subject:
Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.
