Postgres Pro
Downloads
Home   >   mailing lists

Thread: Regarding db performance improvement

Regarding db performance improvement

From
Durgamahesh Manne
Date:


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