Re: Performance problem postgresql 9.5

[Pavan Teja <pavan.postgresdba@xxxxxxxxx>]

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 statistics gathered??

Regards,

Pavan

On Sat, Jun 9, 2018, 1:27 AM Miguel Angel Sanchez Sandoval <massanche@xxxxxxxxx> 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 a lot of CPU, I see the querys active and encounter select fun ('./ 2yhdgrfrt63788') , this did not happen in version 8.4, any help would appreciate it.

regards