Postgres Pro
Downloads
Home   >   mailing lists

Postgres DB Slowness - Mailing list pgsql-admin

From
Subject Postgres DB Slowness
Date
Msg-id 2A91BEF8171A5349931391E0C721CC5359E73FC3@CPEMS-KPN301.KPNCNL.LOCAL
Whole thread Raw
Responses FW: Postgres DB Slowness  (<soumik.bhattacharjee@kpn.com>)
Re: Postgres DB Slowness  (Ron <ronljohnsonjr@gmail.com>)
Re: Postgres DB Slowness  (Jeff Janes <jeff.janes@gmail.com>)
Re: Postgres DB Slowness  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Steven Crandell
Date:
Subject: Re: Postgres PITR: Recovery does not seem to fetch from Archive Dir
Next
From:
Date:
Subject: FW: Postgres DB Slowness