Re: postgres in swap space

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Marc Millas <marc(dot)millas(at)mokadb(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: postgres in swap space
Date: 2025-11-18 03:07:30
Message-ID: aRvi8m1Ay-wajd8F@momjian.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 17, 2025 at 09:49:59PM +0100, Laurenz Albe wrote:
> On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote:
> > Can someone point me to any doc describing why and how much space postgres uses on the swap of a debian machine ?
> > it's an old postgres 10, because it is used by a product for which only this version is certified.
> > (no comment on that, please)
>
> I'm biting down a comment.
>
> PostgreSQL itself doesn't use any swap space.
>
> The kernel can decide to swap out memory used by PostgreSQL. How much that is depends
> on how you configured the Linux kernel and how much memory PostgreSQL uses. The latter
> is mostly determined by "shared_buffers", "work_mem", "maintenance_work_mem" and
> "max_connections".

I wrote a blog entry about swap space:

https://momjian.us/main/blogs/pgblog/2012.html#July_25_2012

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Do not let urgent matters crowd out time for investment in the future.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Colin 't Hart 2025-11-18 09:17:44 Using pgAudit to audit interesting tables for all users except for batch user?
Previous Message Ron Johnson 2025-11-18 00:18:36 Re: postgres in swap space