From: | Attila Soki <atiware(at)gmx(dot)net> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | pgadmin4 rc1 query tool performance |
Date: | 2016-09-06 09:47:46 |
Message-ID: | 57B57481-20CE-4FC5-9DA7-120D72615503@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
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
(sorry for crossposting, i send this e-mail accidentally to pgsql-generat first)
thanks,
Attila
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2016-09-06 09:51:22 | Re: pgadmin4 rc1 query tool performance |
Previous Message | Dave Page | 2016-09-06 08:14:59 | Re: pgAdmin4 1.0-RC1 - Cannot remove nor change length definition on column in "The Table Dialog" |