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 <dizibur...@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. >
