On Tue, 13 Oct 2026 at 12:49, Pavel Stehule <[email protected]> wrote:
> Hi > > út 13. 10. 2026 v 9:21 odesílatel Rick Yost NC Data Team < > [email protected]> napsal: > >> Are there any plans to convert PGAdmin to Java? I deal with very large >> databases and some of the queries I run produce millions of records, I've >> been forced to use other products to extract the data and run my queries, >> but I always like pgAdmin4 for the smaller stuff. I wish it would do it >> for the bigger stuff. But since it's based on chromium, apparently there's >> a problem with downloading that many records after I run the query. >> > > What I know - dbeaver is written in Java, and I doubt it is faster than > pgAdmin4. > > Probably any interactive client written in any language fails out of > memory when you will read (and display) millions of records. > > Modern clients based on usage of some generic grid components are not > designed for displaying millions rows. Maybe if you write your own with > client side buffering in temp files, then it can work. But what I know is > that all modern (universal) clients don't do this. > We use various techniques in pgAdmin, depending on your configuration; for example, batch loading from the backend (think cursors), and a virtual grid so we only need to render a limited number of rows above and below the current viewport. That said, Pavel is quite right - no clients are really designed for displaying millions of rows. It's pointless, as humans can't handle viewing anything even remotely close to that amount of data. -- Dave Page pgAdmin: https://www.pgadmin.org PostgreSQL: https://www.postgresql.org pgEdge: https://www.pgedge.com
