From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: RE: Postgres DB Slowness
Date: Thu, 22 Aug 2019 17:15:51 +0200
Message-ID: <FF8429FA-0692-4F21-9359-96B72F661DFE@jakobs.com> (raw)
In-Reply-To: <2A91BEF8171A5349931391E0C721CC5359E750C4@CPEMS-KPN301.KPNCNL.LOCAL>
References: <2A91BEF8171A5349931391E0C721CC5359E73FC3@CPEMS-KPN301.KPNCNL.LOCAL>
<9840f6c7-5644-1928-e224-b06ecd9297eb@gmail.com>
<2A91BEF8171A5349931391E0C721CC5359E75079@CPEMS-KPN301.KPNCNL.LOCAL>
<71b2a6be-9aae-04bb-d006-c46ded2ab243@gmail.com>
<2A91BEF8171A5349931391E0C721CC5359E750C4@CPEMS-KPN301.KPNCNL.LOCAL>
Could it be that you are comparing the time until first row to time until all rows have been transferred?
Otherwise the times don't seem sensible.
Am 22. August 2019 17:04:19 MESZ schrieb soumik.bhattacharjee@kpn.com:
>From: Ron <ronljohnsonjr@gmail.com><mailto:ronljohnsonjr@gmail.com>
>Sent: Thursday, August 22, 2019 4:26 PM
>To:
>pgsql-admin@lists.postgresql.org<mailto: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?
>
>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.
>
>What does the query plan for that query look like?
>
>What's the table definition?
>
>Is the hardware comparable? (Might it be a SAN or VM issue?)
>
>Table definition is attached here.
>
>EXPLAIN SELECT *
> FROM npcurren.num_aangesloten_nr;
>
>"Seq Scan on num_aangesloten_nr (cost=0.00..268192.46 rows=9649046
>width=113)"
>
>
>
>- Oracle 11gR2 was hosted on physical HP-UX server last
>updated 12 years back- legacy system
>
>- Current postgres server- physical
>
>$ cat /etc/redhat-release
>
>Red Hat Enterprise Linux Server release 7.6 (Maipo)
>
>$ uname -a
>
>Linux slnc7r1513.db.gen.local 3.10.0-957.1.3.el7.x86_64 #1 SMP Thu Nov
>15 17:36:42 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
>
>[postgres@slnc7r1513 ~]$
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
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: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: RE: Postgres DB Slowness
In-Reply-To: <FF8429FA-0692-4F21-9359-96B72F661DFE@jakobs.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