MIME-Version: 1.0
From: Hari Prasad <webdev.byhari@gmail.com>
Date: Sun, 22 Mar 2026 00:22:35 +0530
Message-ID: 
 <CAOXCN+zEsHU970s83oyHByYZC=602o9vBfbs_CJMS+p-WH_vZw@mail.gmail.com>
Subject: [pgAdmin] Startup speed improvements + identified bottlenecks
 (related to issue #9770)
To: pgadmin-hackers@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c073ee064d8d4e5f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOXCN%2BzEsHU970s83oyHByYZC%3D602o9vBfbs_CJMS%2Bp-WH_vZw%40mail.gmail.com>
Precedence: bulk

--000000000000c073ee064d8d4e5f
Content-Type: text/plain; charset="UTF-8"

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.

*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

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

<div dir=3D"ltr">Hi,<br><br>I have=C2=A0been looking into <b>pgAdmin deskto=
p startup performance and identified multiple bottlenecks in the startup pa=
th. </b>A quick summary:<br><br>- Synchronous DB migrations blocking startu=
p<br>- Redundant table validation on every launch<br>- Eager loading of all=
 modules/blueprints<br>- Driver/auth registries loaded upfront<br>- 1s poll=
ing delay in backend readiness detection<br>- Sync logging during startup<b=
r><br>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.=C2=A0<b>Also, the startup feels noticeably =
slower </b>than expected due to the amount of synchronous work being done u=
pfront, which is what led me to dig into this.<br><br><b>Before opening a P=
R </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-org/pgadmin4/issues/9770">#9770</a>, </b>and I plan to address=
 the other bottlenecks incrementally.<br><br>Thanks and regards<div>Hari</d=
iv></div>

--000000000000c073ee064d8d4e5f--