Re: kernel.shmmax and kernel.shmall for Linux server

2021-02-12 Thread Tom Lane
Matthias Apitz writes: > I've read the doc https://www.postgresql.org/docs/13/kernel-resources.html > but I'm still relatively clueless, what to set. For modern PG versions on Linux, you basically shouldn't ever have to touch those numbers. I'd only start to worry if I saw server startup failure

kernel.shmmax and kernel.shmall for Linux server

2021-02-12 Thread Matthias Apitz
Hello, I've read the doc https://www.postgresql.org/docs/13/kernel-resources.html but I'm still relatively clueless, what to set. For example for our standard installations like - RAM: 32 GByte - one PostgreSQL 13.1 server - one database with ~400 tables, 4 GByte in size - 100-200 connecting Po