public inbox for [email protected]help / color / mirror / Atom feed
[pgAdmin] Startup speed improvements + identified bottlenecks (related to issue #9770) 3+ messages / 2 participants [nested] [flat]
* [pgAdmin] Startup speed improvements + identified bottlenecks (related to issue #9770) @ 2026-03-21 18:52 Hari Prasad <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Hari Prasad @ 2026-03-21 18:52 UTC (permalink / raw) To: pgadmin-hackers 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [pgAdmin] Startup speed improvements + identified bottlenecks (related to issue #9770) @ 2026-03-23 05:32 Ashesh Vashi <[email protected]> parent: Hari Prasad <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Ashesh Vashi @ 2026-03-23 05:32 UTC (permalink / raw) To: Hari Prasad <[email protected]>; +Cc: pgadmin-hackers Hi Hari, Thanks for showing interest in the development of pgAdmin4. On Sun, Mar 22, 2026 at 12:22 AM Hari Prasad <[email protected]> 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 > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [pgAdmin] Startup speed improvements + identified bottlenecks (related to issue #9770) @ 2026-03-23 14:18 Hari Prasad <[email protected]> parent: Ashesh Vashi <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Hari Prasad @ 2026-03-23 14:18 UTC (permalink / raw) To: Ashesh Vashi <[email protected]>; +Cc: pgadmin-hackers 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 AM Ashesh Vashi <[email protected]> wrote: > Hi Hari, > > Thanks for showing interest in the development of pgAdmin4. > > On Sun, Mar 22, 2026 at 12:22 AM Hari Prasad <[email protected]> > 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 >> > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2026-03-23 14:18 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-03-21 18:52 [pgAdmin] Startup speed improvements + identified bottlenecks (related to issue #9770) Hari Prasad <[email protected]> 2026-03-23 05:32 ` Ashesh Vashi <[email protected]> 2026-03-23 14:18 ` Hari Prasad <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox