From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Kumar, Mukesh <MKumar@peabodyenergy.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
To: MUKESH KUMAR <mukesh.kumar14@tcs.com>
Subject: Re: Performance for SQL queries on Azure PostgreSQL PaaS instance
Date: Wed, 13 Apr 2022 10:34:24 +0200
Message-ID: <4ae8501377e4ba5155cfee5e6eaca3fe674f7f98.camel@cybertec.at> (raw)
In-Reply-To: <CH0P221MB0474098EC70BA27F2CC2733EDEED9@CH0P221MB0474.NAMP221.PROD.OUTLOOK.COM>
References: <CH0P221MB0474098EC70BA27F2CC2733EDEED9@CH0P221MB0474.NAMP221.PROD.OUTLOOK.COM>
On Tue, 2022-04-12 at 09:10 +0000, Kumar, Mukesh wrote:
> We have recently done the migration from Oracle Database Version 12C to Azure
> PostgreSQL PaaS instance version 11.4 and most of the application functionality
> testing has been over and tested successfully
>
> However, there is 1 process at application level which is taking approx. 10 mins
> in PostgreSQL and in oracle it is taking only 3 mins.
>
> After investigating further we identified that process which is executed from
> application end contains 500 to 600 no of short SQL queries into the database.
> We tried to run the few queries individually on database and they are taking
> less than sec in Postgres Database to execute, and we noticed that in Oracle
> taking half of the time as is taking in PostgreSQL. for ex . in oracle same
> select statement is taking 300 millisecond and in PostgreSQL it is taking
> approx. 600 millisecond which over increases the execution of the process.
>
> Oracle Database are hosted on ON- Prem DC with dedicated application server on
> OnPrem and same for PostgreSQL.
How can a database hosted with Microsoft be on your permises?
Apart from all other things, compare the network latency. If a single request
results in 500 database queries, you will be paying 1000 times the network
latency per request.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
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: laurenz.albe@cybertec.at, MKumar@peabodyenergy.com, mukesh.kumar14@tcs.com
Subject: Re: Performance for SQL queries on Azure PostgreSQL PaaS instance
In-Reply-To: <4ae8501377e4ba5155cfee5e6eaca3fe674f7f98.camel@cybertec.at>
* 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