From: Srikar Vankadaru <srikar@opsveda.com>
To: 'pgsql-admin' <pgsql-admin@postgresql.org>
Subject: Performance tuning/Response times in Postgres 11.2
Date: Wed, 17 Jul 2019 22:23:06 +0530
Message-ID: <005201d53cc0$1da752b0$58f5f810$@opsveda.com> (raw)
Hello Experts,
We are running our application on PostgreSQL version 11.2 on Centos 7 OS.
Have updated below performance related parameters for a 36 vCPU and 72 GB
memory instance and recorded response times.
shared_buffer=14GB
effective_cache_size=50GB
random_page_cost=1.2
work_mem=128MB
maintenance_work_mem=512MB
Now I have upgraded the machine to 72 vCPU and 144 GB memory with below
parameters:
shared_buffer=36GB
effective_cache_size=108GB
random_page_cost=1.2
work_mem=256MB
maintenance_work_mem=1024MB
And performed the same testing and to my surprise the response times are
almost similar and there is no improvement even I am running on the bigger
machine.
I want to understand if I am missing any basic settings that is causing the
slow response times ? Please shed some light here.
Thanks,
Srikar
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: srikar@opsveda.com
Subject: Re: Performance tuning/Response times in Postgres 11.2
In-Reply-To: <005201d53cc0$1da752b0$58f5f810$@opsveda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox