[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Regarding db performance improvement
From:       Durgamahesh Manne <maheshpostgres9 () gmail ! com>
Date:       2020-04-29 11:38:15
Message-ID: CAJCZkoJV+xkp0aih5+SUU_LyaE6A+S2UaX7gZD5VYemM_nzA=Q () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_quote">
	
	


<p style="margin-bottom:0cm;line-height:100%"><br></p><p \
style="margin-bottom:0cm;line-height:100%">Hi to PGDG TEAM<br></p><p \
style="margin-bottom:0cm;line-height:100%"><br></p><p \
style="margin-bottom:0cm;line-height:100%">kernel.shmmax=18446744073692774399</p><p \
style="margin-bottom:0cm;line-height:100%">kernel.shmall=18446744073692774399</p> \
</div><div class="gmail_quote"><br></div><div class="gmail_quote">  I  am using linux \
ubuntu server(16.04) to manage pgsql. So   kernel default  value for kernel.shmax was \
18446744073692774399 &amp; kernel default  value for kernel.shmall was \
18446744073692774399 <br></div><div class="gmail_quote"><br></div><div \
class="gmail_quote">I am using postgresql 12.1 version and ram was 32gb and 8 \
cpu&#39;s</div><div class="gmail_quote"><br></div><div class="gmail_quote">1) Do i \
need to change the default values for  kernel.shmmax &amp;kernel.shmall parameters by \
debugging this below script  </div><div class="gmail_quote">    
                                                                                      \
                
                                                                                 \
<br></div><div class="gmail_quote"> Does pgsql have  performance improvement well by \
changing the kernel.shmmax and kernel.shmall default values ?</div><div \
class="gmail_quote">  #!/bin/bash</div># simple shmsetup script<br>page_size=`getconf \
PAGE_SIZE`<br>phys_pages=`getconf _PHYS_PAGES`<br>shmall=`expr $phys_pages / \
2`<br>shmmax=`expr $shmall \* $page_size`<br>echo kernel.shmmax = $shmmax<br>echo \
kernel.shmall = $shmall<br><div><div class="gmail_quote"><br></div><div \
class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div \
class="gmail_quote">Regards</div><div class="gmail_quote">Durgamahesh \
Manne<br></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]