Re: Fwd: SQL transactions executing from VMSS

2025-04-28 Thread Adrian Klaver
ess is that the Flexible Server(PaaS) is imposing more of an overhead then running your own Postgres instance on IaaS(Azure?). -- Forwarded message - From: *chandan Kumar* <mailto:chandan.issy...@gmail.com>> Date: Tue, Apr 22, 2025 at 4:59 PM Subject: SQL transaction

Re: Fwd: SQL transactions executing from VMSS

2025-04-28 Thread Tom Lane
Laurenz Albe writes: > 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?" The OP did say that the exec

Re: Fwd: SQL transactions executing from VMSS

2025-04-28 Thread Laurenz Albe
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 f

Fwd: SQL transactions executing from VMSS

2025-04-28 Thread chandan Kumar
the same subnet -- Forwarded message - From: chandan Kumar Date: Tue, Apr 22, 2025 at 4:59 PM Subject: SQL transactions executing from VMSS To: Hi Team, Greetings! Kindly help in below situation, where in I see slowness in response time while I do testing running SQL

SQL transactions executing from VMSS

2025-04-22 Thread chandan Kumar
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 s