Correction in version
# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
(1 row)
From: Bhattacharjee, Soumik
Sent: Thursday, August 22, 2019 4:05 PM
To: pgsql-admin@lists.postgresql.org; pgsql-admin@postgresql.org
Subject: Postgres DB Slowness
Importance: High
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