Yes but it's still too slow.
High request count on start up, un-cachable files resulting in rerading the 
same file over and over, un-minified js files, synchronous loading,  some QtWeb 
issues  all contributing.
There is plenty to work on and I am hopeful the pgadmin team can make some big 
improvements.

From: Patrick Headley [mailto:phead...@linxco-inc.com]
Sent: 14 June 2017 16:57
To: Mike Surcouf; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] "pgadmin4" - slow?

It used to take longer. Now, after starting up the times are comparable to 
pgAdmin3.
Patrick Headley
Linx Consulting, Inc.
phead...@linxco-inc.com<mailto:phead...@linxco-inc.com>
(303) 916-5522
www.linxco-inc.com<http://www.linxco-inc.com>
On 06/14/2017 01:29 AM, Mike Surcouf wrote:
A  32 second startup time and a 2-6 seconds to expand each node is encouraging?

From: 
pgadmin-support-ow...@postgresql.org<mailto:pgadmin-support-ow...@postgresql.org>
 [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Patrick Headley
Sent: 14 June 2017 01:23
To: pgadmin-support@postgresql.org<mailto: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.
phead...@linxco-inc.com<mailto:phead...@linxco-inc.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


Reply via email to