On Mon, 2025-04-28 at 13:55 +0530, chandan Kumar wrote: > I did not get any answer till now. If someone has any idea please help me is > getting this resolved. > The issue is - database deployment , sql query to database is slow when we > run database script from > vmss to postgres database in flexible server. both the servers are in US > EAST under the same subnet > > 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.
I think that the answer you didn't get was as helpful as your problem description: "I got some statement that is slow, but I will neither tell you the statement nor show you the execution plan. What is the cause of the slowness?" Yours, Laurenz Albe
