On Mar 13, 2023, at 11:10 AM, Joe Conway <mail@xxxxxxxxxxxxx> wrote: > > On 3/13/23 14:50, Israel Brewster wrote: >> Looks like V2: >> root@novarupta:~# stat -fc %T /sys/fs/cgroup/ >> cgroup2fs > > Interesting -- it does indeed look like you are using cgroup v2 > > So the file you want to look at in that case is: > 8<----------- > cat /sys/fs/cgroup/system.slice/system-postgresql.slice/postgresql@14.service/memory.max > 4294967296 > > cat /sys/fs/cgroup/system.slice/system-postgresql.slice/postgresql@14.service/memory.high > 3221225472 > 8<----------- > If the value comes back as "max" it means no limit is set. This does, in fact, appear to be the case here: root@novarupta:~# cat /sys/fs/cgroup/system.slice/system-postgresql.slice/postgresql@13-main.service/memory.max max root@novarupta:~# cat /sys/fs/cgroup/system.slice/system-postgresql.slice/postgresql@13-main.service/memory.high max root@novarupta:~# which would presumably indicate that it’s a system level limit being exceeded, rather than a postgresql specific one? The syslog specifically says "Memory cgroup out of memory”, if that means something (this is my first exposure to cgroups, if you couldn’t tell). --- Israel Brewster Software Engineer Alaska Volcano Observatory Geophysical Institute - UAF 2156 Koyukuk Drive Fairbanks AK 99775-7320 Work: 907-474-5172 cell: 907-328-9145 > > In this example (on my Linux Mint machine with a custom systemd unit file) I have memory.max set to 4G and memory.high set to 3G. > > The value of memory.max determines when the OOM killer will strike. The value of memory.high will determine when the kernel goes into aggressive memory reclaim (trying to avoid memory.max and thus an OOM kill). > > The corresponding/relevant systemd unit file parameters are: > 8<----------- > MemoryAccounting=yes > MemoryHigh=3G > MemoryMax=4G > 8<----------- > > There are other ways that memory.max may get set, but it seems most likely that the systemd unit file is doing it (if it is in fact set). > > -- > Joe Conway > PostgreSQL Contributors Team > RDS Open Source Databases > Amazon Web Services: https://aws.amazon.com >
