Hi to PGDG TEAM
kernel.shmmax=18446744073692774399 kernel.shmall=18446744073692774399 I am using linux ubuntu server(16.04) to manage pgsql. So kernel default value for kernel.shmax was 18446744073692774399 & kernel default value for kernel.shmall was 18446744073692774399 I am using postgresql 12.1 version and ram was 32gb and 8 cpu's 1) Do i need to change the default values for kernel.shmmax &kernel.shmall parameters by debugging this below script Does pgsql have performance improvement well by changing the kernel.shmmax and kernel.shmall default values ? #!/bin/bash # simple shmsetup script page_size=`getconf PAGE_SIZE` phys_pages=`getconf _PHYS_PAGES` shmall=`expr $phys_pages / 2` shmmax=`expr $shmall \* $page_size` echo kernel.shmmax = $shmmax echo kernel.shmall = $shmall Regards Durgamahesh Manne
