search for: 12kib

Hi All, >>>>> Could anybody point me in the right direction for setting the kernel >>>>> parameter, max_stack_depth, to 10240 for database tuning? >>>>> >>>>> I have currently set it by running 'ulimit -s 10240' but this does not >>>>> survive a reboot. >>>>> >>>>> >>>>

...[Service], [Socket], [Mount], or [Swap] sections, depending on the unit type." However, I assume that you are confused because "ulimit" in a bash shell returns a value in KiB, but LimitSTACK and setrlimit accept a value in bytes. That is, you've decreased the stack size to 12KiB, which is why PostgreSQL segfaults immediately. # cat /etc/systemd/system/postgresql.service .include /lib/systemd/system/postgresql.service [Service] LimitSTACK=12582912 # grep stack /var/lib/pgsql/data/postgresql.conf max_stack_depth = 10MB # min 100kB # systemctl daemon-reload # s...