From: | Justin <zzzzz(dot)graf(at)gmail(dot)com> |
---|---|
To: | Kordexa Stroken <diziburda1(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Performance Problem |
Date: | 2020-03-05 01:37:03 |
Message-ID: | CALL-XeMjUct-g5pY0kYpA_kAgYGx7hCiE05RNRnOYjo9Tf1Xag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Victor Thomsen | 2020-03-05 07:22:08 | Re: Suggestion to reduce COPY command output to csv file |
Previous Message | David G. Johnston | 2020-03-05 01:28:20 | Re: Performance Problem |