Re: "pgadmin4" - slow?

[Yes, I'm on Windows 10]

It does appear that the tool's (or should I say those of the upstream
browser kit / underlying platform) seem to resolve `localhost` very
slowly; it seems about as slow as either a DNS resolver timeout or a
network isn't there. Others mention rewriting the host entry from
`localhost` to `127.0.01` which I did and it does connect to the
database faster.

To me this implies:

* DNS resolution is slow; or

* It's resolved an IPv6 address, found that it can' connect and
then falls back to IPv4.

That said, it still takes at least a minute to even load the program. I
can figure out which of the above two it is but it's not pressing on my
time now (because my alternative simply just works and quickly).

That said, it's difficult to argue that a 30+ second start up time for
the user interface to become responsive (as opposed to useful) is
encouraging and whilst I'm no every day user and might be encouraged by
such oddities to fall back on the faster, and some would arguably say
more powerful, shell with `psql`, others might have simply not used the
tool, i.e. pgadmin4, or worse concluded that Postgresql itself is the
issue.

Does the tool expose any underlying http/web-like server (i.e. is the
tool simply spawning some sort of web process and the GUI is just a
web-browser in a window talking to it)? And more to the point, is there
a way I can point another browser at it? Were this the case, one could
explore another avenue by pointing some other browser with/without
caching on to see if the GUI itself is the pain point?

DSL

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Patrick
Headley
Sent: Tuesday, 13 June 2017 8:23 PM
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] "pgadmin4" - slow?

While I still wish pgAdmin4 was faster to start up I installed pgAdmin4
v1.5 today and performed some tests. Here's what I found.

The test machine is a Windows 7 VirtualBox VM. The host has a 4GHz
processor and an SSD. The host network connection uses an AC 1200 WiFi
card. I believe I'm testing the desktop version of pgAdmin4 since I'm
opening it from the Windows start button.

Starting pgAdmin4: 32 seconds to show "Servers" in the browser tree and
show the opening page.

When I click the plus (+) sign next to servers it takes 5 seconds for my
two local servers to show up. These are on two separate KVM Linux VMs.

It takes between 2 and 6 seconds to open each item in the database
browser tree.

I opened a table of 16,000 rows by clicking on the View All Rows button.
It took 3 seconds to open even though pgAdmin4 said it took only 1
second. In pgAdmin3 on the host machine it took about 1.5 seconds.

I opened a view that has almost 200,000 rows. In pgAdmin3 it takes 7
seconds. pgAdmin4 says it took 5 seconds but it really took 8 seconds.
Overall, the time is comparable between the two versions.

This is very encouraging because when I first tried pgAdmin4 I found it
to be too annoying to use. I will now give it another try.

Patrick Headley
Linx Consulting, Inc.
pheadley(at)linxco-inc(dot)com <mailto:pheadley(at)linxco-inc(dot)com>
(303) 916-5522
www.linxco-inc.com <http://www.linxco-inc.com>

On 06/13/2017 05:26 PM, David Lloyd wrote:

Is it just me or is "pgadmin4" just terribly slow?

I'm running it on a capable HP Laptop (it runs Postgres itself very
well) but "pgadmin4" seems impossibly slow.

Connecting to my Postgres from the local machine doesn't seem to be the
bottleneck (I have a Laravel application that runs just as well with
php's pdo_pgsql as well as pdo_mysql).

Any ideas?

DSL