Re: Performance problem postgresql 9.5

2018-06-09 Thread Miguel Angel Sanchez Sandoval
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

2018-06-09 Thread Andreas Kretschmer
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

2018-06-08 Thread Chapman Flack
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

2018-06-08 Thread Steve Atkins
> 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

2018-06-08 Thread 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 strange command (2yhdgrfrt63788) > that I consume

Re: Performance problem postgresql 9.5

2018-06-08 Thread Pavan Teja
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

Performance problem postgresql 9.5

2018-06-08 Thread Miguel Angel Sanchez Sandoval
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 a lot of CPU, I see the querys active and encounter select fu