public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: chandan Kumar <[email protected]>
To: [email protected]
Subject: Re: Fwd: SQL transactions executing from VMSS
Date: Mon, 28 Apr 2025 11:05:31 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHV6zVn=8LrKPaHL4Qceq6+_jkwJzFpvvrRpVKseditBhtHrFw@mail.gmail.com>
References: <CAHV6zVksAQQDiHXmDB-DHCc2Sk0fJjY_ByC4O-HQjOhUa3fOwg@mail.gmail.com>
	<CAHV6zVn=8LrKPaHL4Qceq6+_jkwJzFpvvrRpVKseditBhtHrFw@mail.gmail.com>

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

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Fwd: SQL transactions executing from VMSS
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox