pgadmin4 rc1 query tool performance
Attila Soki <atiware@gmx.net>
From: Attila Soki <atiware@gmx.net>
To: pgsql-general@postgresql.org
Date: 2016-09-06T09:35:35Z
Lists: pgsql-general
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