Re: Performance Problem
| От | Justin |
|---|---|
| Тема | Re: Performance Problem |
| Дата | |
| Msg-id | CALL-XeMjUct-g5pY0kYpA_kAgYGx7hCiE05RNRnOYjo9Tf1Xag@mail.gmail.com обсуждение исходный текст |
| Ответ на | Performance Problem (Kordexa Stroken <diziburda1@gmail.com>) |
| Список | 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@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.
В списке pgsql-general по дате отправления: