From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Attila Soki <atiware(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgadmin4 rc1 query tool performance |
Date: | 2016-09-06 13:23:26 |
Message-ID: | 1309d187-adff-da96-73a5-80c15f77d32b@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Farber | 2016-09-06 13:32:34 | Re: Check if there 6 last records of same type without gaps |
Previous Message | Alexander Farber | 2016-09-06 13:19:52 | Re: Check if there 6 last records of same type without gaps |