Thread

1. pgadmin4 rc1 query tool performance

   Attila Soki <atiware@gmx.net> — 2016-09-06T09:35:35Z

   Hi,
   
   i testing the latest release of pgadmin4 (rc1) and noticed that the query tool is significantly slower than the query tool in pgadmin3.
   i am not sure if this occurs only on my computer or only under os x (10.10.5) or is this a known behavior.
   
   
   how to repeat:
   create table test1 (a int, t text);
   insert into test1 (select generate_series(0,25000,1),'Lorem ipsum');
   
   create table test2 (a int, t text);
   insert into test2 (select generate_series(0,25000,1),'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent sit amet auctor lectus. Nulla condimentum maximus mauris, ac mattis leo blandit eget.');
   
   
   select * from test1;
   pgadmin3: Total query runtime: 518 msec
   25001 rows retrieved.
   
   pgadmin4 1.0 rc1:
   Total query runtime: 2 secs.
   25001 rows retrieved.
   
   
   
   select * from test2;
   pgadmin3:
   Total query runtime: 2.8 secs
   25001 rows retrieved
   
   pgadmin4 1.0 rc1:
   Total query runtime: 14 secs.
   25001 rows retrieved.
   
   client: os x 10.10.5
   server: debian jessie in vmware, pg9.6-rc1
   
   thanks,
   
   Attila
   
   
   
   

2. Re: pgadmin4 rc1 query tool performance

   Adrian Klaver <adrian.klaver@aklaver.com> — 2016-09-06T13:23:26Z

   On 09/06/2016 02:35 AM, Attila Soki wrote:
   > Hi,
   >
   > i testing the latest release of pgadmin4 (rc1) and noticed that the query tool is significantly slower than the query tool in pgadmin3.
   > i am not sure if this occurs only on my computer or only under os x (10.10.5) or is this a known behavior.
   
   I don't know. You might get an answer quicker at the link below though:
   
   https://www.postgresql.org/list/pgadmin-hackers/
   
   >
   >
   > how to repeat:
   > create table test1 (a int, t text);
   > insert into test1 (select generate_series(0,25000,1),'Lorem ipsum');
   >
   > create table test2 (a int, t text);
   > insert into test2 (select generate_series(0,25000,1),'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent sit amet auctor lectus. Nulla condimentum maximus mauris, ac mattis leo blandit eget.');
   >
   >
   > select * from test1;
   > pgadmin3: Total query runtime: 518 msec
   > 25001 rows retrieved.
   >
   > pgadmin4 1.0 rc1:
   > Total query runtime: 2 secs.
   > 25001 rows retrieved.
   >
   >
   >
   > select * from test2;
   > pgadmin3:
   > Total query runtime: 2.8 secs
   > 25001 rows retrieved
   >
   > pgadmin4 1.0 rc1:
   > Total query runtime: 14 secs.
   > 25001 rows retrieved.
   >
   > client: os x 10.10.5
   > server: debian jessie in vmware, pg9.6-rc1
   >
   > thanks,
   >
   > Attila
   >
   >
   >
   
   
   -- 
   Adrian Klaver
   adrian.klaver@aklaver.com
   
   
   

3. Re: pgadmin4 rc1 query tool performance

   Attila Soki <atiware@gmx.net> — 2016-09-06T16:40:15Z

   > Am 06.09.2016 um 15:23 schrieb Adrian Klaver <adrian.klaver@aklaver.com>:
   > 
   > On 09/06/2016 02:35 AM, Attila Soki wrote:
   >> Hi,
   >> 
   >> i testing the latest release of pgadmin4 (rc1) and noticed that the query tool is significantly slower than the query tool in pgadmin3.
   >> i am not sure if this occurs only on my computer or only under os x (10.10.5) or is this a known behavior.
   > 
   > I don't know. You might get an answer quicker at the link below though:
   > 
   > https://www.postgresql.org/list/pgadmin-hackers/
   
   sorry for the noise, i posted this accidentally here instead of pgadmin-support. i got already an answer there.
   
   Attila
   
   

4. Re: pgadmin4 rc1 query tool performance

   Martijn Tonies (Upscene Productions) <m.tonies@upscene.com> — 2016-09-07T06:29:37Z

   >>> i testing the latest release of pgadmin4 (rc1) and noticed that the 
   >>> query tool is significantly slower than the query tool in pgadmin3.
   >>> i am not sure if this occurs only on my computer or only under os x 
   >>> (10.10.5) or is this a known behavior.
   >>
   >> I don't know. You might get an answer quicker at the link below though:
   >>
   >> https://www.postgresql.org/list/pgadmin-hackers/
   >
   >sorry for the noise, i posted this accidentally here instead of 
   >pgadmin-support. i got already an answer there.
   
   What was the answer?
   
   
   With regards,
   
   Martijn Tonies
   Upscene Productions
   
   
   
   

5. Re: pgadmin4 rc1 query tool performance

   rob stone <floriparob@gmail.com> — 2016-09-07T13:10:55Z

   Hello,
   On Tue, 2016-09-06 at 18:40 +0200, Attila Soki wrote:
   > > 
   > > Am 06.09.2016 um 15:23 schrieb Adrian Klaver <adrian.klaver@aklaver
   > > .com>:
   > > 
   > > On 09/06/2016 02:35 AM, Attila Soki wrote:
   > > > 
   > > > Hi,
   > > > 
   > > > i testing the latest release of pgadmin4 (rc1) and noticed that
   > > > the query tool is significantly slower than the query tool in
   > > > pgadmin3.
   > > > i am not sure if this occurs only on my computer or only under os
   > > > x (10.10.5) or is this a known behavior.
   > > 
   > > I don't know. You might get an answer quicker at the link below
   > > though:
   > > 
   > > https://www.postgresql.org/list/pgadmin-hackers/
   > 
   > sorry for the noise, i posted this accidentally here instead of
   > pgadmin-support. i got already an answer there.
   > 
   > Attila
   > 
   
   IMO the answer is nonsensical.
   
   I'd do the following:-
   
   1) Alter your postgresql.conf to log every statement.
   2) Restart the server.
   3) Run your tests again.
   4) Examine the postgresl.log file for the queries created and compare
   them. Also, pgadmin might be querying the catalogues in an inefficient
   manner thus leading to the increases in elapsed times.
   
   My 2 cents worth.
   
   HTH,
   Rob
   
   
   

6. Re: pgadmin4 rc1 query tool performance

   Attila Soki <atiware@gmx.net> — 2016-09-07T13:41:45Z

   > Am 07.09.2016 um 08:29 schrieb Martijn Tonies (Upscene Productions) <m.tonies@upscene.com>:
   > 
   >>>> i testing the latest release of pgadmin4 (rc1) and noticed that the query tool is significantly slower than the query tool in pgadmin3.
   >>>> i am not sure if this occurs only on my computer or only under os x (10.10.5) or is this a known behavior.
   >>> 
   >>> I don't know. You might get an answer quicker at the link below though:
   >>> 
   >>> https://www.postgresql.org/list/pgadmin-hackers/
   >> 
   >> sorry for the noise, i posted this accidentally here instead of pgadmin-support. i got already an answer there.
   > 
   > What was the answer?
   
   http://www.mail-archive.com/pgadmin-support@postgresql.org/msg15121.html
   
   >Dave Page Tue, 06 Sep 2016 03:48:07 -0700>
   >
   >On Tue, Sep 6, 2016 at 11:41 AM, Michal Kozusznik
   ><kozusznik.mic...@ifortuna.cz> wrote:
   >> On 6.9.2016 11:51, Dave Page wrote:
   >>>
   >>> On Tue, Sep 6, 2016 at 10:47 AM, Attila Soki <atiw...@gmx.net> wrote:
   >>>>
   >>>> Hi,
   >>>>
   >>>> i testing pgadmin4 (rc1) and noticed that the query tool is significantly
   >>>> slower than the query tool in pgadmin3.
   >>>> i am not sure if this occurs only on my computer or only under os x
   >>>> (10.10.5) or is this a known behavior.
   >>>
   >>> It's a natural consequence of it being a web application.
   >>
   >>
   >> Indeed It is, but not to the extent shown by OP.
   >> Or in other words, it should be considered as show stopper for tool like
   >> pgAdmin.
   >>
   >> I really cannot imaging daily work with such slow tool. I still hope in
   >> significant improvement in this area.
   >
   >Patches are welcome
   
   Attila