Re: pgadmin4 data browsing

Hi,

It is pgadmin4 9.3. Try to fetch 10000 records (increase it in preferences) and try to pg up or pg downd continuously.

i can do 100k records this way in google spreadsheet inside chrome easy.

Andrew
________________________________
From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Sent: Wednesday, May 7, 2025 6:06 AM
To: Andrew Protasov <a_protasov(at)hotmail(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: pgadmin4 data browsing

Hi Andrew,

We're already using react-data-grid which uses virtualization and is quite fast. You might be using an older version where the data was fetched from the server dynamically on scroll.

On Wed, May 7, 2025 at 4:00 PM Andrew Protasov <a_protasov(at)hotmail(dot)com<mailto:a_protasov(at)hotmail(dot)com>> wrote:
Hi,

Browsing of query result set using page up/page down keys is very slow and the slowest that I have seen in any sql tool. You need to user proper js widget like slickgrid for it, which has decent performance. Pgadmin3 did not have this issue at all.

Andrew

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"