Re: postgres in swap space

2025-11-18 Thread Marc Millas
Clear ! thanks Laurentz Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Nov 17, 2025 at 9:50 PM 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 d

Re: postgres in swap space

2025-11-17 Thread Bruce Momjian
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 produ

Re: postgres in swap space

2025-11-17 Thread Ron Johnson
On Mon, Nov 17, 2025 at 4:41 PM Adrian Klaver wrote: > On 11/17/25 13:12, Ron Johnson wrote: > > On Mon, Nov 17, 2025 at 3:50 PM Laurenz Albe > > wrote: > > > > On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > > > Can someone point me to any doc d

Re: postgres in swap space

2025-11-17 Thread Adrian Klaver
On 11/17/25 13:12, Ron Johnson wrote: On Mon, Nov 17, 2025 at 3:50 PM 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 debia

Re: postgres in swap space

2025-11-17 Thread Ron Johnson
On Mon, Nov 17, 2025 at 3:50 PM 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 whic

Re: postgres in swap space

2025-11-17 Thread Laurenz Albe
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,

Re: postgres in swap space

2025-11-17 Thread pg254kl
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

Re: postgres in swap space

2025-11-17 Thread Ron Johnson
On Mon, Nov 17, 2025 at 12:25 PM Marc Millas 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 o

postgres in swap space

2025-11-17 Thread Marc Millas
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 +3360785033