MIME-Version: 1.0
References: 
 <CAOXCN+zEsHU970s83oyHByYZC=602o9vBfbs_CJMS+p-WH_vZw@mail.gmail.com>
In-Reply-To: 
 <CAOXCN+zEsHU970s83oyHByYZC=602o9vBfbs_CJMS+p-WH_vZw@mail.gmail.com>
From: Ashesh Vashi <ashesh.vashi@enterprisedb.com>
Date: Mon, 23 Mar 2026 11:02:53 +0530
Message-ID: 
 <CAG7mmoyTWSxzgqL0yChOMnjynfy75GSO0iCe0iJrHKmEqx9yAA@mail.gmail.com>
Subject: Re: [pgAdmin] Startup speed improvements + identified bottlenecks
 (related to issue #9770)
To: Hari Prasad <webdev.byhari@gmail.com>
Cc: pgadmin-hackers@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007932fe064daa5ed7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAG7mmoyTWSxzgqL0yChOMnjynfy75GSO0iCe0iJrHKmEqx9yAA%40mail.gmail.com>
Precedence: bulk

--0000000000007932fe064daa5ed7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Hari,

Thanks for showing interest in the development of pgAdmin4.

On Sun, Mar 22, 2026 at 12:22=E2=80=AFAM Hari Prasad <webdev.byhari@gmail.c=
om>
wrote:

> Hi,
>
> I have been looking into *pgAdmin desktop startup performance and
> identified multiple bottlenecks in the startup path. *A quick summary:
>
> - Synchronous DB migrations blocking startup
> - Redundant table validation on every launch
> - Eager loading of all modules/blueprints
>
- Driver/auth registries loaded upfront
>
- 1s polling delay in backend readiness detection
> - Sync logging during startup
>

> As a first step, I have implemented a small fix for the polling issue
> (adaptive polling instead of fixed 1000ms), which improves responsiveness
> without touching backend logic. *Also, the startup feels noticeably
> slower *than expected due to the amount of synchronous work being done
> upfront, which is what led me to dig into this.
>
Sounds good to me.

-- Ashesh

>
> *Before opening a PR *for this change, I wanted to check if this approach
> is acceptable.
>
> This is *part of ongoing work around issue #9770
> <https://github.com/pgadmin-org/pgadmin4/issues/9770>, *and I plan to
> address the other bottlenecks incrementally.
>
> Thanks and regards
> Hari
>

--0000000000007932fe064daa5ed7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Hi Hari,<br><br>Thanks for showing i=
nterest in the development of pgAdmin4.</div></div><br><div class=3D"gmail_=
quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, =
Mar 22, 2026 at 12:22=E2=80=AFAM Hari Prasad &lt;<a href=3D"mailto:webdev.b=
yhari@gmail.com">webdev.byhari@gmail.com</a>&gt; wrote:<br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi,<br><br>I have=
=C2=A0been looking into <b>pgAdmin desktop startup performance and identifi=
ed multiple bottlenecks in the startup path. </b>A quick summary:<br><br>- =
Synchronous DB migrations blocking startup<br>- Redundant table validation =
on every launch<br>- Eager loading of all modules/blueprints=C2=A0</div></b=
lockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr=
">- Driver/auth registries loaded upfront=C2=A0</div></blockquote><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">- 1s polling dela=
y in backend readiness detection<br>- Sync logging during startup=C2=A0</di=
v></blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0p=
x 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><br>As a first step, I have implemented a small fix for the pollin=
g issue (adaptive polling instead of fixed 1000ms), which improves responsi=
veness without touching backend logic.=C2=A0<b>Also, the startup feels noti=
ceably slower </b>than expected due to the amount of synchronous work being=
 done upfront, which is what led me to dig into this.<br></div></blockquote=
><div>Sounds good to me.</div><div><br></div><div>-- Ashesh</div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><br><b>Before open=
ing a PR </b>for this change, I wanted to check if this approach is accepta=
ble.<br><br>This is <b>part of ongoing work around issue <a href=3D"https:/=
/github.com/pgadmin-org/pgadmin4/issues/9770" target=3D"_blank">#9770</a>, =
</b>and I plan to address the other bottlenecks incrementally.<br><br>Thank=
s and regards<div>Hari</div></div>
</blockquote></div></div>

--0000000000007932fe064daa5ed7--