SQL transactions executing from VMSS - Mailing list pgsql-general

From chandan Kumar
Subject SQL transactions executing from VMSS
Date
Msg-id CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com
Whole thread Raw
Responses Fwd: SQL transactions executing from VMSS
List pgsql-general

Hi Team,
Greetings!

Kindly help in below situation, where in I see slowness in response time while I do testing running SQL transaction in batches from VMSS to postgres database in flexible server(PaaS) 14.17 version. VMSS to IaaS(postgres db on ubuntu) is faster than VMSs to PaaS. 14 version is same on both the system. response size is same but response time is almost 2.5x more on PaaS. I see dynatrace is showing more time is on waiting time. Query plan is same on both the system. If i run single sql transaction from pg admin it is executing in same time.
 what can cause this slowness, any idea please.
--
With warm regards
     Chandan

pgsql-general by date:

Previous
From: Yongye Serkfem
Date:
Subject: Oracle_fdw
Next
From: Laurenz Albe
Date:
Subject: Re: Oracle_fdw