Azure VM's are incredibly slow. I couldn't host a OpenStreetMap
database because the disk IO would die off from reasonable performance
to about 5KB/s and the data import wouldn't finish. Reboot and it would
be fine for a while then repeat. $400 a month for that.
You are better off on bare metal o
On Wed, Apr 13, 2022 at 10:34:24AM +0200, Laurenz Albe wrote:
> On Tue, 2022-04-12 at 09:10 +, 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
> >
-
From: Laurenz Albe
Sent: Wednesday, April 13, 2022 2:04 PM
To: Kumar, Mukesh ; pgsql-performa...@postgresql.org;
MUKESH KUMAR
Subject: Re: Performance for SQL queries on Azure PostgreSQL PaaS instance
On Tue, 2022-04-12 at 09:10 +, Kumar, Mukesh wrote:
> We have recently done the migrat
On Tue, 2022-04-12 at 09:10 +, 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 pro
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
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
