Postgres Pro
Downloads
Home   >   mailing lists

RE: Postgres DB Slowness - Mailing list pgsql-admin

From
Subject RE: Postgres DB Slowness
Date
Msg-id 2A91BEF8171A5349931391E0C721CC5359E75079@CPEMS-KPN301.KPNCNL.LOCAL
Whole thread Raw
In response to Re: Postgres DB Slowness  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Postgres DB Slowness
List pgsql-admin
Tree view

 

From: Ron <ronljohnsonjr@gmail.com>
Sent: Thursday, August 22, 2019 4:26 PM
To: pgsql-admin@lists.postgresql.org
Subject: Re: Postgres DB Slowness

 

On 8/22/19 9:04 AM, soumik.bhattacharjee@kpn.com wrote:

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.


Have you validated that the Postgres server has the same indexes?

If so, did you ANALYZE all the tables?

--
Angular momentum makes the world go 'round.

 

 

Yes Ron, we migrated from Oracle as per same structure and indexes.

 

I did the analyze for 2-3 tables now as per my SQL query I wrote and also ran for one particular table below –

 

VACUUM (FULL,ANALYZE) table_name.

 

 

 

 

pgsql-admin by date:

Previous
From: Perry Chandler
Date:
Subject: RE: Postgres DB Slowness
Next
From: Ron
Date:
Subject: Re: Postgres DB Slowness