Performance tuning/Response times in Postgres 11.2

From: "Srikar Vankadaru" <srikar(at)opsveda(dot)com>
To: "'pgsql-admin'" <pgsql-admin(at)postgresql(dot)org>
Subject: Performance tuning/Response times in Postgres 11.2
Date: 2019-07-17 16:53:06
Message-ID: 005201d53cc0$1da752b0$58f5f810$@opsveda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2019-07-17 18:20:43 Re: Performance tuning/Response times in Postgres 11.2
Previous Message John Scalia 2019-07-17 13:51:08 Re: pg_restore and the -C flag