Long query results rendering

Поиск
Список
Период
Сортировка
От Igor Mazur
Тема Long query results rendering
Дата
Msg-id CACbBOUB06Gf9uWsHyHKhAgxK3M-6yAKnb_yj9zHXSn-c=HjV9A@mail.gmail.com
обсуждение исходный текст
Список pgadmin-support
Hi,

I've found minor but annoying issue. 
With high-latency network (in my case Wi-Fi and server on the opposite side of the Earth) 
Every, even very light query, takes ~ 2-3 seconds. 

Interesting that a main query executes in 150 ms. (and less than 30 ms local on server)

But there are a lot of such queries in pgadmin.log (two queries for every column)
---
SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 20
SELECT CASE WHEN typbasetype=0 THEN oid else typbasetype END AS basetype
  FROM pg_type WHERE oid=20
---
and they take also 150 ms every

So with such queries - common time of rendering ~ 2-3 seconds.

Is it possible to cache this data or request them in advance? I suppose this will increase performance in tenth times.

В списке pgadmin-support по дате отправления:

Предыдущее
От: Bill Iglesias
Дата:
Сообщение: Trouble Installing pgadmin3 1.20 on Debian Wheezy
Следующее
От: Joe Strout
Дата:
Сообщение: all useful options disabled in the Import dialog