Re: [GENERAL] pgadmin4 rc1 query tool performance

2016-09-07 Thread Attila Soki 

> Am 07.09.2016 um 08:29 schrieb Martijn Tonies (Upscene Productions) 
> :
> 
 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/
>> 
>> sorry for the noise, i posted this accidentally here instead of 
>> pgadmin-support. i got already an answer there.
> 
> What was the answer?

http://www.mail-archive.com/pgadmin-support@postgresql.org/msg15121.html

>Dave Page Tue, 06 Sep 2016 03:48:07 -0700>
>
>On Tue, Sep 6, 2016 at 11:41 AM, Michal Kozusznik
> wrote:
>> On 6.9.2016 11:51, Dave Page wrote:
>>>
>>> On Tue, Sep 6, 2016 at 10:47 AM, Attila Soki  wrote:

 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.
>>>
>>> It's a natural consequence of it being a web application.
>>
>>
>> Indeed It is, but not to the extent shown by OP.
>> Or in other words, it should be considered as show stopper for tool like
>> pgAdmin.
>>
>> I really cannot imaging daily work with such slow tool. I still hope in
>> significant improvement in this area.
>
>Patches are welcome

Attila



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgadmin4 rc1 query tool performance

2016-09-07 Thread rob stone 
Hello,
On Tue, 2016-09-06 at 18:40 +0200, Attila Soki wrote:
> > 
> > Am 06.09.2016 um 15:23 schrieb Adrian Klaver  > .com>:
> > 
> > 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/
> 
> sorry for the noise, i posted this accidentally here instead of
> pgadmin-support. i got already an answer there.
> 
> Attila
> 

IMO the answer is nonsensical.

I'd do the following:-

1) Alter your postgresql.conf to log every statement.
2) Restart the server.
3) Run your tests again.
4) Examine the postgresl.log file for the queries created and compare
them. Also, pgadmin might be querying the catalogues in an inefficient
manner thus leading to the increases in elapsed times.

My 2 cents worth.

HTH,
Rob


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgadmin4 rc1 query tool performance

2016-09-07 Thread Martijn Tonies (Upscene Productions) 
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/


sorry for the noise, i posted this accidentally here instead of 
pgadmin-support. i got already an answer there.


What was the answer?


With regards,

Martijn Tonies
Upscene Productions



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgadmin4 rc1 query tool performance

2016-09-06 Thread Attila Soki 

> Am 06.09.2016 um 15:23 schrieb Adrian Klaver :
> 
> 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/

sorry for the noise, i posted this accidentally here instead of 
pgadmin-support. i got already an answer there.

Attila

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgadmin4 rc1 query tool performance

2016-09-06 Thread Adrian Klaver 

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

[GENERAL] pgadmin4 rc1 query tool performance

2016-09-06 Thread Attila Soki 
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



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general