Re: PGAdmin 9.18 support

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

In response to

Browse pgadmin-support by date

  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