RE: Postgres DB Slowness

Rebuilt all of the indexes?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: 22 August 2019 15:26
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres DB Slowness

On 8/22/19 9:04 AM, soumik(dot)bhattacharjee(at)kpn(dot)com<mailto:soumik(dot)bhattacharjee(at)kpn(dot)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.
TaxCalc is a trading name of Acorah Software Products Limited, a company registered in England and Wales number 03948264. Registered Office: Rubra One, Fishponds Road, Wokingham, Berkshire, RG41 2GY.

Any files attached to this email will have been checked by us with virus detection software before transmission. You should carry out your own virus checks before opening any attachment. Acorah Software Products Limited accepts no liability for any loss or damage which may be caused by software viruses.

The contents of this e-mail (including any attachments) may be CONFIDENTIAL and is for the intended addressee only. If you are not the intended recipient of this e-mail, any disclosure, copying, distribution or use of its contents is strictly prohibited, and you should please notify the sender immediately and then delete it (including any attachments) from your system.

Any unauthorised use, dissemination of the information, or copying of this message is prohibited.