Re: [pgadmin-support] "pgadmin4" - slow?
| От | David Lloyd |
|---|---|
| Тема | Re: [pgadmin-support] "pgadmin4" - slow? |
| Дата | |
| Msg-id | 001901d2e503$f5a06d80$e0e14880$@adam.com.au обсуждение исходный текст |
| Ответ на | Re: [pgadmin-support] "pgadmin4" - slow? (Patrick Headley <pheadley@linxco-inc.com>) |
| Список | pgadmin-support |
[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@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Patrick Headley
Sent: Tuesday, 13 June 2017 8:23 PM
To: pgadmin-support@postgresql.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@linxco-inc.com
(303) 916-5522
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
В списке pgadmin-support по дате отправления:
Предыдущее
От: Dave PageДата:
Сообщение: Re: [pgadmin-support] Serious feedback and questions about the futureof pgAdmin.