Thread: pgadmin4 rc1 query tool performance
Hi, i testing the latest release of pgadmin4 (rc1) and noticed that the query tool is significantly slower than the query toolin 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 sitamet 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
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 toolin 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. Praesentsit 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
> 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 querytool 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
>>> 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
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
> 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 querytool 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