Hi there, I just stumbled upon a query that executes fast in Navicat but needs remarkably more time in pgAdmin4. So far I hadn't noticed any difference in both programs.
Out of curiosity, I decided to crosscheck the timings I got with other tools. You find the results below. Altogether, the query takes roughly 0.4 seconds when executed via psql command line tool, using Navicat or via the Adminer web frontend. phpPgAdmin needs about twice the time, but pgAdmin4 about four times more. Is this due to the client server architecture? Is there a way to get similar performance to the other tools? Best Johannes [psql 9.5.5] (9729 rows) Time: 334.753 ms [Navicat 11.2.15] 9729 records 0.36 sec elapsed [Adminer 4.2.5] 9,729 rows (0.365 s) [phpPgAdmin 5.1] 9729 row(s) Total runtime: 761.667 ms SQL executed. [pgAdmin4 1.1 (on OS X 10.11.6)] Total query runtime: 2 secs. 9729 rows retrieved. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
