Re: Performance Problem

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 serve

Re: Performance Problem

On Wed, Mar 4, 2020 at 6:17 PM Kordexa Stroken 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

Re: Performance problem postgresql 9.5

Guys, indeed I had an intruder, with the recent migration I installed a remote mirror that had a vulnerability. Thank you very much for your fast response. My best regards Libre de virus

Re: Performance problem postgresql 9.5

Am 08.06.2018 um 22:09 schrieb Alvaro Herrera: On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote: Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the database experiences slowness, I execute the linux top command and it shows me a postgres user process executing a st

Re: Performance problem postgresql 9.5

On 06/08/2018 03:56 PM, Miguel Angel Sanchez Sandoval wrote: > I see the querys active and encounter > select fun ('./ 2yhdgrfrt63788') Would it be possible (observing appropriate precautions for a compromised server) to report here the language and definition of any function(s) named 'fun' in th

Re: Performance problem postgresql 9.5

> On Jun 8, 2018, at 1:09 PM, Alvaro Herrera wrote: > > On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote: > >> Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the >> database experiences slowness, I execute the linux top command and it shows >> me a postgres user proc

Re: Performance problem postgresql 9.5

On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote: > Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the > database experiences slowness, I execute the linux top command and it shows > me a postgres user process executing a strange command (2yhdgrfrt63788) > that I consume

Re: Performance problem postgresql 9.5

Could you please give more briefing about the queries executed. Let me know whether they are dml or ddl. Provide information like how long and from what time the queries are in running state, so that we can find a way to find the exact pain area. What is the size of the database?? When were the s