Re: Intermittent aggressive use of SWAP space by PostgreSQL despite availability of HUGE amounts of RAM for a small database.

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
freeRAM. We have a 100 GB database with 256 GB RAM on the server so there is no shortage of RAM nor shortage in
PostgreSQLbuffer 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.