pgadmin4 rc1 query tool performance

From: Attila Soki <atiware(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pgadmin4 rc1 query tool performance
Date: 2016-09-06 09:35:35
Message-ID: 9A81E950-BBC0-4C2B-A493-412738D34473@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2016-09-06 10:32:00 Check if there 6 last records of same type without gaps
Previous Message Glyn Astill 2016-09-06 09:03:56 Re: postgres driver for mysql