| From: | Miguel Angel Sanchez Sandoval <massanche(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Performance problem postgresql 9.5 |
| Date: | 2018-06-08 19:56:28 |
| Message-ID: | CANozSKLGgWDpzfua2L=OGFN=Dg3Po98UjqJJ18gBVFR1-yK5+A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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 | Pavan Teja | 2018-06-08 20:04:41 | Re: Performance problem postgresql 9.5 |
| Previous Message | Saeed Ahmed (DB) | 2018-06-08 18:27:53 | pg_basebackup: could not get write-ahead log end position from server: ERROR |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Teja | 2018-06-08 20:04:41 | Re: Performance problem postgresql 9.5 |
| Previous Message | Havasvölgyi Ottó | 2018-06-08 19:01:47 | Use index with x = ANY(array_column) expression |