From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Frits Jalvingh <jal@etc.to>
To: Kumar, Mukesh <mkumar@peabodyenergy.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: MUKESH KUMAR <mukesh.kumar14@tcs.com>
Subject: Re: Performance for SQL queries on Azure PostgreSQL PaaS instance
Date: Tue, 12 Apr 2022 17:06:38 +0200
Message-ID: <461e3601-24f1-d8e8-da5d-3e5de1ae45c1@enterprisedb.com> (raw)
In-Reply-To: <CAKhTGFU6NaEdV_sZJXsvqrfHnnNrgM0t+SK8UKJNwZORqPXjOQ@mail.gmail.com>
References: <CH0P221MB0474098EC70BA27F2CC2733EDEED9@CH0P221MB0474.NAMP221.PROD.OUTLOOK.COM>
<CAKhTGFU6NaEdV_sZJXsvqrfHnnNrgM0t+SK8UKJNwZORqPXjOQ@mail.gmail.com>
On 4/12/22 16:23, Frits Jalvingh wrote:
> You might be comparing apples and pears..
>
> Your Oracle is running on prem while Postgres is running on Azure. Azure
> does not really have disks; it seems to have just a bunch of old people
> writing the data on paper - I/O on Azure is ridiculously slow. What
> disks/hardware does the on-prem Oracle have?
>
Right. It'd be good to do some basic system benchmarks first, e.g. using
"fio" or similar tools, before comparing query timings. It's quite
possible this is due to Azure storage being slower than physical drives
in the on-premise system.
If that does not explain this, I suggest picking a single query and
focus on it, instead of investigating all queries at once. There's a
nice wiki page explaining what info to provide:
https://wiki.postgresql.org/wiki/Slow_Query_Questions
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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-performance@postgresql.org
Cc: tomas.vondra@enterprisedb.com, jal@etc.to, mkumar@peabodyenergy.com, mukesh.kumar14@tcs.com
Subject: Re: Performance for SQL queries on Azure PostgreSQL PaaS instance
In-Reply-To: <461e3601-24f1-d8e8-da5d-3e5de1ae45c1@enterprisedb.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