From: | Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)com> |
---|---|
To: | Miguel Angel Sanchez Sandoval <massanche(at)gmail(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Performance problem postgresql 9.5 |
Date: | 2018-06-08 20:04:41 |
Message-ID: | CACh9nsaLSVG-eNvZwLHwO0y2jiV7C9tN=JvhfkLHOWYp_2CCFA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(at)gmail(dot)com> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2018-06-08 20:09:54 | Re: Performance problem postgresql 9.5 |
Previous Message | Miguel Angel Sanchez Sandoval | 2018-06-08 19:56:28 | Performance problem postgresql 9.5 |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2018-06-08 20:09:54 | Re: Performance problem postgresql 9.5 |
Previous Message | Miguel Angel Sanchez Sandoval | 2018-06-08 19:56:28 | Performance problem postgresql 9.5 |