From: | andrew cooke <andrew(at)acooke(dot)org> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | "Kumar, Mukesh" <MKumar(at)peabodyenergy(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, MUKESH KUMAR <mukesh(dot)kumar14(at)tcs(dot)com> |
Subject: | Re: Performance for SQL queries on Azure PostgreSQL PaaS instance |
Date: | 2022-04-13 11:17:56 |
Message-ID: | 20220413111756.niehtkrpcv4ptf2h@acooke.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Wed, Apr 13, 2022 at 10:34:24AM +0200, Laurenz Albe wrote:
> 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?
Not OP, but it couldn't it be
https://azure.microsoft.com/en-us/overview/azure-stack/ ?
> 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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | ldh@laurent-hasson.com | 2022-04-13 15:36:19 | RE: An I/O error occurred while sending to the backend (PG 13.4) |
Previous Message | Kumar, Mukesh | 2022-04-13 08:42:59 | RE: Performance for SQL queries on Azure PostgreSQL PaaS instance |