Date: Mon, 19 Aug 2024 13:20:20 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Aleksander Alekseev <aleksander@timescale.com>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>,
	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.
Message-ID: <ZsN-1NPvoxdD9DZY@momjian.us>
References: 
 <PH0PR22MB3810DDCBB930DABE9BBF16C5B8A82@PH0PR22MB3810.namprd22.prod.outlook.com>
 <CAJ7c6TM2wRBw+M8E_aSvw7Lp+bzqNiB0ZNFh2NpTumPcKxiURg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAJ7c6TM2wRBw+M8E_aSvw7Lp+bzqNiB0ZNFh2NpTumPcKxiURg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZsN-1NPvoxdD9DZY%40momjian.us>
Precedence: bulk

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.