Slowness issue in database

IQBAL, MOHAMMAD 5 Reputation points
2024-04-26T11:33:46.1733333+00:00

Database is migrated from Oracle to Postgresql.

In pg database insert query is running longer and taking 3Hours to complete where as same insert query is taking 30 sec at oracle platform.

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,276 Reputation points Microsoft Employee
    2024-04-29T08:12:27.2233333+00:00

    Hi IQBAL, MOHAMMAD •,

    Welcome to Microsoft Q&A forum.

    As I understand, you are getting slowness in execution of queries in Azure Database for PostgreSQL.

    Please refer to the detailed documentation here https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/how-to-identify-slow-queries for identify the slowness of queries and https://video2.skills-academy.com/en-us/azure/postgresql/single-server/concepts-query-performance-insight.

    Refer to similar Q&A posts with solutions:

    https://video2.skills-academy.com/en-us/answers/questions/587136/slow-perfomance-of-azure-postgresql-db

    https://video2.skills-academy.com/en-us/answers/questions/1321158/slow-queries-on-azure-postgresql-flexible-server

    Please take a look and let us know if this helps.

    Let us know if you have any specific query with some sample information so that we can assist or suggest.

    Thanks

    0 comments