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

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

Thanks for the feedback.

Opened a PR #9782
<https://github.com/pgadmin-org/pgadmin4/pull/9782/commits> as the first
step. I will address all other issues one after the other.

Regards
Hari

On Mon, Mar 23, 2026 at 11:03=E2=80=AFAM Ashesh Vashi <ashesh.vashi@enterpr=
isedb.com>
wrote:

> 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=
.com>
> 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 responsivenes=
s
>> 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
>>
>

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

<div dir=3D"ltr">Thanks for the feedback.=C2=A0<div><br></div><div>Opened=
=C2=A0a PR <a href=3D"https://github.com/pgadmin-org/pgadmin4/pull/9782/com=
mits">#9782</a>=C2=A0as the first step. I will address all other issues one=
 after the other.<br><br>Regards<br>Hari=C2=A0</div></div><br><div class=3D=
"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">O=
n Mon, Mar 23, 2026 at 11:03=E2=80=AFAM Ashesh Vashi &lt;<a href=3D"mailto:=
ashesh.vashi@enterprisedb.com">ashesh.vashi@enterprisedb.com</a>&gt; wrote:=
<br></div><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=
"><div dir=3D"ltr"><div>Hi Hari,<br><br>Thanks for showing interest in the =
development of pgAdmin4.</div></div><br><div class=3D"gmail_quote"><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.byhari@gmail.com" target=3D"_blank">we=
bdev.byhari@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><div dir=3D"ltr">Hi,<br><br>I have=C2=A0been looking i=
nto <b>pgAdmin desktop startup performance and identified multiple bottlene=
cks in the startup path. </b>A quick summary:<br><br>- Synchronous DB migra=
tions blocking startup<br>- Redundant table validation on every launch<br>-=
 Eager loading of all modules/blueprints=C2=A0</div></blockquote><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">- Driver/auth regi=
stries loaded upfront=C2=A0</div></blockquote><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><div dir=3D"ltr">- 1s polling delay in backend readine=
ss detection<br>- Sync logging during startup=C2=A0</div></blockquote><bloc=
kquote 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"><br>As a firs=
t step, I have implemented a small fix for the polling issue (adaptive poll=
ing instead of fixed 1000ms), which improves responsiveness without touchin=
g backend logic.=C2=A0<b>Also, the startup feels noticeably slower </b>than=
 expected due to the amount of synchronous work being done upfront, which i=
s what led me to dig into this.<br></div></blockquote><div>Sounds good to m=
e.</div><div><br></div><div>-- Ashesh</div><blockquote 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"><br><b>Before opening a PR </b>for this =
change, I wanted to check if this approach is acceptable.<br><br>This is <b=
>part of ongoing work around issue <a href=3D"https://github.com/pgadmin-or=
g/pgadmin4/issues/9770" target=3D"_blank">#9770</a>, </b>and I plan to addr=
ess the other bottlenecks incrementally.<br><br>Thanks and regards<div>Hari=
</div></div>
</blockquote></div></div>
</blockquote></div>

--0000000000001f2872064db1b5c1--