| From: | Igor Mazur <igor(dot)kozlov(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Long query results rendering |
| Date: | 2015-01-09 11:54:45 |
| Message-ID: | CACbBOUB06Gf9uWsHyHKhAgxK3M-6yAKnb_yj9zHXSn-c=HjV9A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Strout | 2015-01-09 16:17:14 | all useful options disabled in the Import dialog |
| Previous Message | Bill Iglesias | 2015-01-08 15:25:45 | Trouble Installing pgadmin3 1.20 on Debian Wheezy |