Postgres Pro
Downloads
Home   >   mailing lists

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 Muhammad Waqas
Subject Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.
Date
Msg-id CAHYHq4VQVz54gPyZDHpfY78urkoyw-VBBh8ju7a6=eOW9ap33w@mail.gmail.com
Whole thread Raw
In response to RE: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.  (Mohammed Siddiqui <msiddiqui@net32.com>)
List pgsql-bugs
Tree view
Huge size of memory allocation and 3000 max_connection may caused swap space issue.

2024년 7월 25일 (목) 오후 5:01, Mohammed Siddiqui <msiddiqui@net32.com>님이 작성:
Configuration file is attached.

-----Original Message-----
From: Aleksander Alekseev <aleksander@timescale.com>
Sent: Tuesday, July 23, 2024 4:33 AM
To: pgsql-bugs@lists.postgresql.org
Cc: Mohammed Siddiqui <msiddiqui@net32.com>; Ken Sollars <Ken@net32.com>; Matt Elliott <melliott@net32.com>
Subject: Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.

Hi,

> 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.

--
Best regards,
Aleksander Alekseev

pgsql-bugs by date:

Previous
From: Zaid Shabbir
Date:
Subject: Re: Installer initialization failed
Next
From: Zaid Shabbir
Date:
Subject: Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.