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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general