pgadmin3 incredibly slow over network

2019-02-06 Thread Nikita Kiryanov
If I use pgAdmin3 to query a remote database with SELECT * FROM big_table, the whole thing takes 1.5 minutes until I get my results. If I run the same query, from the same computer, to the same remote database, using a different client (HeidiSQL, or even pgsql), it takes 5 seconds. I run pgA

RE: pgadmin3 incredibly slow over network

2019-02-06 Thread Nikita Kiryanov
Hi Ricardo, I tried to reverse the order (first HeidiSQL then pgAdmin), but the result was the same. From: Ricardo Martin Gomez [mailto:rimartingo...@hotmail.com] Sent: Wednesday, February 6, 2019 12:43 PM To: Nikita Kiryanov ; pgadmin-support@lists.postgresql.org Subject: RE: pgadmin3

RE: pgadmin3 incredibly slow over network

2019-02-06 Thread Nikita Kiryanov
HeidiSQL, it looks like the vast majority of the delay might be network transfer. What could pgAdmin be doing that slows down network I/O so significantly? From: Ricardo Martin Gomez [mailto:rimartingo...@hotmail.com] Sent: Wednesday, February 6, 2019 12:57 PM To: Nikita Kiryanov ; pgadmin