Thread: [pgadmin-support] pgAdmin4 speed
There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about.
I'm running the python server script and then using pgAdmin4 in a web browser. I suggest that folks who are bothered by the speed (lack of) in standalone mode give the server + browser setup a try. The server is launched with a single command:
python /path/to/pgAdmin4.py
then navigate to:
localhost:5050
A good suggestion, but there are a few things wrong with that.
1. Not everyone has python installed on Windows 10, at least not by default. So it requires python
to be downloaded and installed just to run PgAdmin4.
2. Many of us do not want to use PgAdmin4 in a browser. We want it in standalone mode.
3. It's a workaround that says it's ok to ignore a major problem.
From: Richard Greenwood <richard.greenwood@gmail.com>
To: pgadmin-support@postgresql.org
Sent: Wednesday, May 24, 2017 9:15 AM
Subject: [pgadmin-support] pgAdmin4 speed
1. Not everyone has python installed on Windows 10, at least not by default. So it requires python
to be downloaded and installed just to run PgAdmin4.
2. Many of us do not want to use PgAdmin4 in a browser. We want it in standalone mode.
3. It's a workaround that says it's ok to ignore a major problem.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: Richard Greenwood <richard.greenwood@gmail.com>
To: pgadmin-support@postgresql.org
Sent: Wednesday, May 24, 2017 9:15 AM
Subject: [pgadmin-support] pgAdmin4 speed
There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about.
I'm running the python server script and then using pgAdmin4 in a web browser. I suggest that folks who are bothered by the speed (lack of) in standalone mode give the server + browser setup a try. The server is launched with a single command:
python /path/to/pgAdmin4.py
then navigate to:
localhost:5050
I just changed from Windows desktop to SERVER_MODE with apache and it is completely different app.
So much faster. Looks like there is something seriously wrong with the Qt implementation.
Plus I only have to install it once.
It’s a pain to setup in server mode though.
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Richard Greenwood
Sent: 24 May 2017 14:15
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgAdmin4 speed
There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about.
I'm running the python server script and then using pgAdmin4 in a web browser. I suggest that folks who are bothered by the speed (lack of) in standalone mode give the server + browser setup a try. The server is launched with a single command:
python /path/to/pgAdmin4.py
then navigate to:
localhost:5050
On Thu, May 25, 2017 at 5:09 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
I just changed from Windows desktop to SERVER_MODE with apache and it is completely different app.
So much faster. Looks like there is something seriously wrong with the Qt implementation.
Plus I only have to install it once.
It’s a pain to setup in server mode though.
From: pgadmin-support-owner@postgres
ql.org [mailto:pgadmin-support-owner@ postgresql.org] On Behalf Of Richard Greenwood
Sent: 24 May 2017 14:15
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgAdmin4 speed
There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about.
I'm running the python server script and then using pgAdmin4 in a web browser. I suggest that folks who are bothered by the speed (lack of) in standalone mode give the server + browser setup a try. The server is launched with a single command:
python /path/to/pgAdmin4.py
then navigate to:
localhost:5050
I, too, am finding pgAdmin 4 v1.5 in standalone mode to be much slower than previous versions on Windows 10. Here are some examples:
- Launching the application takes 32 seconds.
- Expanding the Servers icon takes 6 seconds to populate.
- Expanding the Databases icon takes 10 seconds to populate.
I don't have the exact numbers from the pgAdmin 4 v1.4 or v1.3, but I don't believe it was this slow. As for pgAdmin III numbers:
- Launching takes 3 seconds.
- Expanding the Servers and Databases icons are near instantaneous.
pgAdmin 4 About:
Version1.5CopyrightCopyright 2013 - 2017, The pgAdmin Development TeamPython Version2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC v.1500 32 bit (Intel)]Flask Version0.11.1Application ModeDesktopCurrent Userpgadmin4@pgadmin.org
Thanks,
Shira
Agreed, setting it up under Apache is a pain. But you can use:
python /path/to/pgAdmin4.py &
to launch a standalone server on port 5050. I have that in my .profile in Linux, Windows users could have it in autoexec.bat or whatever the current equivalent of that is.
I'm not saying that's an ideal solution for everyone, but for me that configuration is easy to maintain and provides a faster, more stable pgAdmin4 than pgAdmin3.
--
On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
I just changed from Windows desktop to SERVER_MODE with apache and it is completely different app.
So much faster. Looks like there is something seriously wrong with the Qt implementation.
Plus I only have to install it once.
It’s a pain to setup in server mode though.
From: pgadmin-support-owner@
postgresql.org [mailto:pgadmin-support-owner@ postgresql.org] On Behalf Of Richard Greenwood
Sent: 24 May 2017 14:15
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgAdmin4 speed
There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about.
I'm running the python server script and then using pgAdmin4 in a web browser. I suggest that folks who are bothered by the speed (lack of) in standalone mode give the server + browser setup a try. The server is launched with a single command:
python /path/to/pgAdmin4.py
then navigate to:
localhost:5050
Richard W. Greenwood, PLS
www.greenwoodmap.com
www.greenwoodmap.com
It's starting to become clear that the speed issues we've had reported are specific to the desktop runtime under Windows - which explains why most of the developers don't see them as the majority of us use Macs. Thank you to those that have provided tips and info to help narrow this down. I'm at PGCon at the moment and don't have a Windows VM on the machine I have with me, so I plan to look into this next week when I'm back. On Thu, May 25, 2017 at 3:44 PM, Richard Greenwood <richard.greenwood@gmail.com> wrote: > Agreed, setting it up under Apache is a pain. But you can use: > python /path/to/pgAdmin4.py & > to launch a standalone server on port 5050. I have that in my .profile in > Linux, Windows users could have it in autoexec.bat or whatever the current > equivalent of that is. > I'm not saying that's an ideal solution for everyone, but for me that > configuration is easy to maintain and provides a faster, more stable > pgAdmin4 than pgAdmin3. > > On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote: >> >> I just changed from Windows desktop to SERVER_MODE with apache and it is >> completely different app. >> >> So much faster. Looks like there is something seriously wrong with the >> Qt implementation. >> >> Plus I only have to install it once. >> >> It’s a pain to setup in server mode though. >> >> >> >> From: pgadmin-support-owner@postgresql.org >> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Richard Greenwood >> Sent: 24 May 2017 14:15 >> To: pgadmin-support@postgresql.org >> Subject: [pgadmin-support] pgAdmin4 speed >> >> >> >> There were several recent comments on this list about pgAdmin4 being slow >> which surprised me as I've found it to be faster than pgAdmin3. But then I >> saw pgAdmin4 on a Windows machine in standalone mode and realized what >> people are complaining about. >> >> >> >> I'm running the python server script and then using pgAdmin4 in a web >> browser. I suggest that folks who are bothered by the speed (lack of) in >> standalone mode give the server + browser setup a try. The server is >> launched with a single command: >> >> python /path/to/pgAdmin4.py >> >> then navigate to: >> >> localhost:5050 >> >> >> >> Rich >> >> >> >> -- >> >> Richard W. Greenwood, PLS >> www.greenwoodmap.com > > > > > -- > Richard W. Greenwood, PLS > www.greenwoodmap.com -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Thu, May 25, 2017 at 1:06 PM, Dave Page <dpage@pgadmin.org> wrote:
It's starting to become clear that the speed issues we've had reported
are specific to the desktop runtime under Windows - which explains why
most of the developers don't see them as the majority of us use Macs.
Thank you to those that have provided tips and info to help narrow
this down. I'm at PGCon at the moment and don't have a Windows VM on
the machine I have with me, so I plan to look into this next week when
I'm back.
Thanks Dave. Also, here's another data point: A colleague in my office who has pgAdmin 4 v1.22.2 desktop on Windows 10 installed says it only takes 3 seconds to launch. So seems like a Windows performance issue might have been introduced between 1.2 and 1.5.
--On Thu, May 25, 2017 at 3:44 PM, Richard Greenwood
<richard.greenwood@gmail.com> wrote:
> Agreed, setting it up under Apache is a pain. But you can use:
> python /path/to/pgAdmin4.py &
> to launch a standalone server on port 5050. I have that in my .profile in
> Linux, Windows users could have it in autoexec.bat or whatever the current
> equivalent of that is.
> I'm not saying that's an ideal solution for everyone, but for me that
> configuration is easy to maintain and provides a faster, more stable
> pgAdmin4 than pgAdmin3.
>
> On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf <mikes@surcouf.co.uk> wrote:
>>
>> I just changed from Windows desktop to SERVER_MODE with apache and it is
>> completely different app.
>>
>> So much faster. Looks like there is something seriously wrong with the
>> Qt implementation.
>>
>> Plus I only have to install it once.
>>
>> It’s a pain to setup in server mode though.
>>
>>
>>
>> From: pgadmin-support-owner@postgresql.org
>> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Richard Greenwood
>> Sent: 24 May 2017 14:15
>> To: pgadmin-support@postgresql.org
>> Subject: [pgadmin-support] pgAdmin4 speed
>>
>>
>>
>> There were several recent comments on this list about pgAdmin4 being slow
>> which surprised me as I've found it to be faster than pgAdmin3. But then I
>> saw pgAdmin4 on a Windows machine in standalone mode and realized what
>> people are complaining about.
>>
>>
>>
>> I'm running the python server script and then using pgAdmin4 in a web
>> browser. I suggest that folks who are bothered by the speed (lack of) in
>> standalone mode give the server + browser setup a try. The server is
>> launched with a single command:
>>
>> python /path/to/pgAdmin4.py
>>
>> then navigate to:
>>
>> localhost:5050
>>
>>
>>
>> Rich
>>
>>
>>
>> --
>>
>> Richard W. Greenwood, PLS
>> www.greenwoodmap.com
>
>
>
>
> --
> Richard W. Greenwood, PLS
> www.greenwoodmap.com
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On Thu, May 25, 2017 at 4:14 PM, Shira Bezalel <shira@sfei.org> wrote: > > On Thu, May 25, 2017 at 1:06 PM, Dave Page <dpage@pgadmin.org> wrote: >> >> It's starting to become clear that the speed issues we've had reported >> are specific to the desktop runtime under Windows - which explains why >> most of the developers don't see them as the majority of us use Macs. >> >> Thank you to those that have provided tips and info to help narrow >> this down. I'm at PGCon at the moment and don't have a Windows VM on >> the machine I have with me, so I plan to look into this next week when >> I'm back. >> > > Thanks Dave. Also, here's another data point: A colleague in my office who > has pgAdmin 4 v1.22.2 desktop on Windows 10 installed says it only takes 3 > seconds to launch. So seems like a Windows performance issue might have been > introduced between 1.2 and 1.5. 1.22.2 was pgAdmin III, which is totally different from pgAdmin 4. Is that really what he's running, or do you mean pgAdmin 4 v1.2? > > >> >> On Thu, May 25, 2017 at 3:44 PM, Richard Greenwood >> <richard.greenwood@gmail.com> wrote: >> > Agreed, setting it up under Apache is a pain. But you can use: >> > python /path/to/pgAdmin4.py & >> > to launch a standalone server on port 5050. I have that in my .profile >> > in >> > Linux, Windows users could have it in autoexec.bat or whatever the >> > current >> > equivalent of that is. >> > I'm not saying that's an ideal solution for everyone, but for me that >> > configuration is easy to maintain and provides a faster, more stable >> > pgAdmin4 than pgAdmin3. >> > >> > On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf <mikes@surcouf.co.uk> >> > wrote: >> >> >> >> I just changed from Windows desktop to SERVER_MODE with apache and it >> >> is >> >> completely different app. >> >> >> >> So much faster. Looks like there is something seriously wrong with the >> >> Qt implementation. >> >> >> >> Plus I only have to install it once. >> >> >> >> It’s a pain to setup in server mode though. >> >> >> >> >> >> >> >> From: pgadmin-support-owner@postgresql.org >> >> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Richard >> >> Greenwood >> >> Sent: 24 May 2017 14:15 >> >> To: pgadmin-support@postgresql.org >> >> Subject: [pgadmin-support] pgAdmin4 speed >> >> >> >> >> >> >> >> There were several recent comments on this list about pgAdmin4 being >> >> slow >> >> which surprised me as I've found it to be faster than pgAdmin3. But >> >> then I >> >> saw pgAdmin4 on a Windows machine in standalone mode and realized what >> >> people are complaining about. >> >> >> >> >> >> >> >> I'm running the python server script and then using pgAdmin4 in a web >> >> browser. I suggest that folks who are bothered by the speed (lack of) >> >> in >> >> standalone mode give the server + browser setup a try. The server is >> >> launched with a single command: >> >> >> >> python /path/to/pgAdmin4.py >> >> >> >> then navigate to: >> >> >> >> localhost:5050 >> >> >> >> >> >> >> >> Rich >> >> >> >> >> >> >> >> -- >> >> >> >> Richard W. Greenwood, PLS >> >> www.greenwoodmap.com >> > >> > >> > >> > >> > -- >> > Richard W. Greenwood, PLS >> > www.greenwoodmap.com >> >> >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> >> >> -- >> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgadmin-support > > > > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Thu, May 25, 2017 at 1:26 PM, Dave Page <dpage@pgadmin.org> wrote:
On Thu, May 25, 2017 at 4:14 PM, Shira Bezalel <shira@sfei.org> wrote:
>
> On Thu, May 25, 2017 at 1:06 PM, Dave Page <dpage@pgadmin.org> wrote:
>>
>> It's starting to become clear that the speed issues we've had reported
>> are specific to the desktop runtime under Windows - which explains why
>> most of the developers don't see them as the majority of us use Macs.
>>
>> Thank you to those that have provided tips and info to help narrow
>> this down. I'm at PGCon at the moment and don't have a Windows VM on
>> the machine I have with me, so I plan to look into this next week when
>> I'm back.
>>
>
> Thanks Dave. Also, here's another data point: A colleague in my office who
> has pgAdmin 4 v1.22.2 desktop on Windows 10 installed says it only takes 3
> seconds to launch. So seems like a Windows performance issue might have been
> introduced between 1.2 and 1.5.
1.22.2 was pgAdmin III, which is totally different from pgAdmin 4. Is
that really what he's running, or do you mean pgAdmin 4 v1.2?
Ack, sorry about that. Miscommunication. He was referring to pgAdmin III 1.22.2.
With his pgAdmin 4 v1.4 installation, he reports launching took 57 seconds the first time and about 27 seconds the second time.
Shira
>
>
>>
>> On Thu, May 25, 2017 at 3:44 PM, Richard Greenwood
>> <richard.greenwood@gmail.com> wrote:
>> > Agreed, setting it up under Apache is a pain. But you can use:
>> > python /path/to/pgAdmin4.py &
>> > to launch a standalone server on port 5050. I have that in my .profile
>> > in
>> > Linux, Windows users could have it in autoexec.bat or whatever the
>> > current
>> > equivalent of that is.
>> > I'm not saying that's an ideal solution for everyone, but for me that
>> > configuration is easy to maintain and provides a faster, more stable
>> > pgAdmin4 than pgAdmin3.
>> >
>> > On Thu, May 25, 2017 at 6:09 AM, Mike Surcouf <mikes@surcouf.co.uk>
>> > wrote:
>> >>
>> >> I just changed from Windows desktop to SERVER_MODE with apache and it
>> >> is
>> >> completely different app.
>> >>
>> >> So much faster. Looks like there is something seriously wrong with the
>> >> Qt implementation.
>> >>
>> >> Plus I only have to install it once.
>> >>
>> >> It’s a pain to setup in server mode though.
>> >>
>> >>
>> >>
>> >> From: pgadmin-support-owner@postgresql.org
>> >> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Richard
>> >> Greenwood
>> >> Sent: 24 May 2017 14:15
>> >> To: pgadmin-support@postgresql.org
>> >> Subject: [pgadmin-support] pgAdmin4 speed
>> >>
>> >>
>> >>
>> >> There were several recent comments on this list about pgAdmin4 being
>> >> slow
>> >> which surprised me as I've found it to be faster than pgAdmin3. But
>> >> then I
>> >> saw pgAdmin4 on a Windows machine in standalone mode and realized what
>> >> people are complaining about.
>> >>
>> >>
>> >>
>> >> I'm running the python server script and then using pgAdmin4 in a web
>> >> browser. I suggest that folks who are bothered by the speed (lack of)
>> >> in
>> >> standalone mode give the server + browser setup a try. The server is
>> >> launched with a single command:
>> >>
>> >> python /path/to/pgAdmin4.py
>> >>
>> >> then navigate to:
>> >>
>> >> localhost:5050
>> >>
>> >>
>> >>
>> >> Rich
>> >>
>> >>
>> >>
>> >> --
>> >>
>> >> Richard W. Greenwood, PLS
>> >> www.greenwoodmap.com
>> >
>> >
>> >
>> >
>> > --
>> > Richard W. Greenwood, PLS
>> > www.greenwoodmap.com
>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>> --
>> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
>
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company