From: Bruce Momjian <bruce@momjian.us>
To: Aleksander Alekseev <aleksander@timescale.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Cc: Mohammed Siddiqui <msiddiqui@net32.com>
Cc: Ken Sollars <Ken@net32.com>
Cc: 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.
Date: Mon, 19 Aug 2024 13:20:20 -0400
Message-ID: <ZsN-1NPvoxdD9DZY@momjian.us> (raw)
In-Reply-To: <CAJ7c6TM2wRBw+M8E_aSvw7Lp+bzqNiB0ZNFh2NpTumPcKxiURg@mail.gmail.com>
References: <PH0PR22MB3810DDCBB930DABE9BBF16C5B8A82@PH0PR22MB3810.namprd22.prod.outlook.com>
<CAJ7c6TM2wRBw+M8E_aSvw7Lp+bzqNiB0ZNFh2NpTumPcKxiURg@mail.gmail.com>
On Tue, Jul 23, 2024 at 11:33:05AM +0300, Aleksander Alekseev wrote:
> 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.
I find running this query more helpful because it only shows non-default
settings, and potentially shows per user/database changes too:
-- show non-default server settings
SELECT name, current_setting(name), source
FROM pg_settings
WHERE source NOT IN ('default', 'override');
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: bruce@momjian.us, aleksander@timescale.com, pgsql-bugs@lists.postgresql.org, msiddiqui@net32.com, Ken@net32.com, melliott@net32.com
Subject: Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.
In-Reply-To: <ZsN-1NPvoxdD9DZY@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox