From: Perry Chandler <Perry.Chandler@taxcalc.com>
To: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: RE: Postgres DB Slowness
Date: Thu, 22 Aug 2019 14:33:59 +0000
Message-ID: <2bda7f9ac7d845fd941c185740a3a396@taxcalc.com> (raw)
In-Reply-To: <9840f6c7-5644-1928-e224-b06ecd9297eb@gmail.com>
References: <2A91BEF8171A5349931391E0C721CC5359E73FC3@CPEMS-KPN301.KPNCNL.LOCAL>
<9840f6c7-5644-1928-e224-b06ecd9297eb@gmail.com>
Rebuilt all of the indexes?
From: Ron <ronljohnsonjr@gmail.com>
Sent: 22 August 2019 15:26
To: pgsql-admin@lists.postgresql.org
Subject: Re: Postgres DB Slowness
On 8/22/19 9:04 AM, soumik.bhattacharjee@kpn.com<mailto: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.
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Perry.Chandler@taxcalc.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: RE: Postgres DB Slowness
In-Reply-To: <2bda7f9ac7d845fd941c185740a3a396@taxcalc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox