From: | Patrick Headley <pheadley(at)linxco-inc(dot)com> |
---|---|
To: | Mike Surcouf <mikes(at)surcouf(dot)co(dot)uk>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: "pgadmin4" - slow? |
Date: | 2017-06-14 15:56:32 |
Message-ID: | 6dfcd42d-6612-c791-5247-8582876ae017@linxco-inc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
It used to take longer. Now, after starting up the times are comparable
to pgAdmin3.
*/Patrick Headley/*
Linx Consulting, Inc.
pheadley(at)linxco-inc(dot)com
(303) 916-5522
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-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] *On Behalf Of *Patrick
> Headley
> *Sent:* 14 June 2017 01:23
> *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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Surcouf | 2017-06-14 16:07:31 | Re: "pgadmin4" - slow? |
Previous Message | Stephen Frost | 2017-06-14 15:43:13 | Migrating this list to PGLister on Friday, June 16th, 1300 UTC |