From: | Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Regarding db performance improvement |
Date: | 2020-04-29 11:26:15 |
Message-ID: | CAJCZkoJV+xkp0aih5+SUU_LyaE6A+S2UaX7gZD5VYemM_nzA=Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Gauthier | 2020-04-29 15:17:40 | Why is a check constraint not working ? |
Previous Message | Adrian Klaver | 2020-04-29 00:29:01 | Re: GIN Expression Indexes |