| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Rick(at)ncdatateam(dot)org, pgadmin-support(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PGAdmin 9.18 support |
| Date: | 2026-10-13 12:12:34 |
| Message-ID: | CA+OCxozT3K9WAoj3gz3YZKLkLjwRPQ0MZg_5W4+AbMi_3DLejA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Tue, 13 Oct 2026 at 12:49, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> Hi
>
> út 13. 10. 2026 v 9:21 odesílatel Rick Yost NC Data Team <
> Rick(at)ncdatateam(dot)org> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Duncan | 2026-10-13 13:31:17 | Re: PGAdmin 9.18 support |
| Previous Message | Pavel Stehule | 2026-10-13 11:49:08 | Re: PGAdmin 9.18 support |