Date: Mon, 17 Nov 2025 22:07:30 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Marc Millas <marc.millas@mokadb.com>,
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: postgres in swap space
Message-ID: <aRvi8m1Ay-wajd8F@momjian.us>
References: <CADX_1ab6U-T_SZP7L1uiOMNdBm9vV07u22i-KgQvu1E=BHguWA@mail.gmail.com>
 <ef9349445ef9bd14e1e9285c4eb3e6d48f47ec9b.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <ef9349445ef9bd14e1e9285c4eb3e6d48f47ec9b.camel@cybertec.at>
Archived-At: <https://www.postgresql.org/message-id/aRvi8m1Ay-wajd8F%40momjian.us>
Precedence: bulk

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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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