Re: Performance problem postgresql 9.5

2018-06-09 Thread Miguel Angel Sanchez Sandoval
bmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> 2018-06-08 14:56 GMT-05:00 Miguel Angel Sanchez Sandoval < massan...@gmail.com>

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