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
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 |