pgadmin4 rc1 query tool performance
От | Attila Soki |
---|---|
Тема | pgadmin4 rc1 query tool performance |
Дата | |
Msg-id | 9A81E950-BBC0-4C2B-A493-412738D34473@gmx.net обсуждение исходный текст |
Ответы |
Re: pgadmin4 rc1 query tool performance
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: