Postgres Pro
Downloads
Home   >   mailing lists

Thread: Performance Problem

Performance Problem

From
Kordexa Stroken
Date:
 Hello iam working on a project and using Postgresql 10.My main server 2 x E5 2680 v3 Cpu NVMe M.2 500 Gb Disk 32 GB Ram and my postgresql server is a VM(VirtualBox) Centos7 16GB ram Postgresql 10 Db size 4 GB and my solution is N-Tier Architecture & 40 online user . My postgresql.conf here:
   
    https://pastebin.com/Y8ybSxq4
   
I have performance problem with postgresql.What is wrong ? I can not find what is problem.  

Re: Performance Problem

From
"David G. Johnston"
Date:
On Wed, Mar 4, 2020 at 6:17 PM Kordexa Stroken <diziburda1@gmail.com> wrote:
 Hello iam working on a project and using Postgresql 10.My main server 2 x E5 2680 v3 Cpu NVMe M.2 500 Gb Disk 32 GB Ram and my postgresql server is a VM(VirtualBox) Centos7 16GB ram Postgresql 10 Db size 4 GB and my solution is N-Tier Architecture & 40 online user . My postgresql.conf here:
   
    https://pastebin.com/Y8ybSxq4
   
I have performance problem with postgresql.What is wrong ? I can not find what is problem.  

Not really sure how anyone else would be able to either.

Here are some suggestions for how to request help that is actionable:


Start specific and then generalize.

David J.

Re: Performance Problem

From
Justin
Date:
taking a quick glance at config file I do not see any modifications to any key settings

shared_buffers,
efffecttive cache size
work_mem

meaning the server is running at the default settings which results in horrible performance

here is a website that gives suggested config changes based on server hardware.  https://pgtune.leopard.in.ua/#/

That said to get help on slow queries  need to describe the  tables in question, post the query in question along with explain/analyze results  

On Wed, Mar 4, 2020 at 8:17 PM Kordexa Stroken <diziburda1@gmail.com> wrote:
 Hello iam working on a project and using Postgresql 10.My main server 2 x E5 2680 v3 Cpu NVMe M.2 500 Gb Disk 32 GB Ram and my postgresql server is a VM(VirtualBox) Centos7 16GB ram Postgresql 10 Db size 4 GB and my solution is N-Tier Architecture & 40 online user . My postgresql.conf here:
   
    https://pastebin.com/Y8ybSxq4
   
I have performance problem with postgresql.What is wrong ? I can not find what is problem.