public inbox for [email protected]  

help / color / mirror / Atom feed

postgres in swap space
3+ messages / 3 participants
[nested] [flat]

* postgres in swap space
@ 2025-11-17 17:25  Marc Millas <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Marc Millas @ 2025-11-17 17:25 UTC (permalink / raw)
  To: [email protected] <[email protected]>

hello,
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)

regards

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgres in swap space
@ 2025-11-17 18:16  Ron Johnson <[email protected]>
  parent: Marc Millas <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Ron Johnson @ 2025-11-17 18:16 UTC (permalink / raw)
  To: [email protected] <[email protected]>

On Mon, Nov 17, 2025 at 12:25 PM Marc Millas <[email protected]> wrote:

> hello,
> 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)
>

Swap as in RAM swap space?  If so, then it uses as much or as little as
Linux thinks needs to be used, given the amount of RAM.

effective_cache_size, work_mem, shared_buffers,
maintenance_work_mem, max_worker_* and max_parallel_* affect how much RAM
PG uses, in conjunction with the number of active connections (including
maintenance work).

https://postgresqlco.nf/doc/en/param/ is a handy resource.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgres in swap space
@ 2025-11-17 20:23  [email protected]
  parent: Marc Millas <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: [email protected] @ 2025-11-17 20:23 UTC (permalink / raw)
  To: [email protected] <[email protected]>

Putting memory pages to swap is the decision of the linux virtual memory 
manager not postgres.  If your db machine is swapping, first make sure 
you have set sensible values for the ram related settings like 
shared_buffers (25%), effective_cache_size (75%) and work_mem (keep it 
modest at 4 to 16 MB).

On 11/17/25 12:25 PM, Marc Millas - marc.millas at mokadb.com wrote:
> hello,
> 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)
>
> regards
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com <http://www.mokadb.com;
>
-- 
regards,
Kiriakos Georgiou


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2025-11-17 20:23 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-11-17 17:25 postgres in swap space Marc Millas <[email protected]>
2025-11-17 18:16 ` Ron Johnson <[email protected]>
2025-11-17 20:23 ` [email protected]

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox