| From: | <soumik(dot)bhattacharjee(at)kpn(dot)com> |
|---|---|
| To: | <pgsql-admin(at)lists(dot)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Postgres DB Slowness |
| Date: | 2019-08-22 14:04:38 |
| Message-ID: | 2A91BEF8171A5349931391E0C721CC5359E73FC3@CPEMS-KPN301.KPNCNL.LOCAL |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello Members,
We have the below PostgreSQL database recently migrated from Oracle.
The postgres DB parameters are attached here.
# DB Version: 10
# OS Type: Linux
# Total Memory (RAM): 30 GB
#CPU
nproc --all
2
There is huge slowness in the database now with any queries.
Oracle - Select * from TABLENAME- in takes 0.009 milliseconds
PostgreSQL - Same query takes more than 2 minutes.
Your immediate response is appreciated.
Thanks
Soumik
| Attachment | Content-Type | Size |
|---|---|---|
| Postgres-DB_Parameters.txt | text/plain | 39.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | soumik.bhattacharjee | 2019-08-22 14:09:56 | FW: Postgres DB Slowness |
| Previous Message | Steven Crandell | 2019-08-22 09:46:18 | Re: Postgres PITR: Recovery does not seem to fetch from Archive Dir |