public inbox for [email protected]
help / color / mirror / Atom feedpostgres in swap space
3+ messages / 3 participants
[nested] [flat]
* postgres in swap space
@ 2025-11-17 17:25 Marc Millas <[email protected]>
2025-11-17 18:16 ` Re: postgres in swap space Ron Johnson <[email protected]>
2025-11-17 20:23 ` Re: postgres in swap space [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 17:25 postgres in swap space Marc Millas <[email protected]>
@ 2025-11-17 18:16 ` Ron Johnson <[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 17:25 postgres in swap space Marc Millas <[email protected]>
@ 2025-11-17 20:23 ` [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