Hi,<br /><br /><br />I've been using pgAdmin for a long time but over time it has become more and more frustrating to
useit.<br />It's a great application that performs everything I need, however, when first connecting to servers with
manydatabases, each with many tables, views and other objects (over a VPN) it can often take 20-30 seconds while
pgAdminis hung before it completes running all the prefetch queries.<br /><br />I've analyzed its logs and it appears
thatsome queries are the main culprit.<br /><br /><br />For example (15-20 seconds to run this):<br />SELECT oid,
format_type(oid,NULL) AS typname FROM pg_type<br /><br />We have quite a few entries there (every toasted table, every
viewand every table have a couple of entries there).<br />SELECT count(*) AS typname FROM pg_type<br />35468<br /><br
/>Also,this same query gets apparently issued twice:<br />2010-01-13 09:44:15 QUERY : Set query (pgdb:5432): SELECT
oid,format_type(oid, NULL) AS typname FROM pg_type<br />2010-01-13 09:44:31 QUERY : Set query (pgdb:5432): SELECT oid,
format_type(oid,NULL) AS typname FROM pg_type<br />2010-01-13 09:44:52 STATUS : Restoring previous environment...
(37.31secs)<br /><br />Causing the application a long time to "connect".<br />I was wondering if there's either a way
tobring a partial subset of the data (is all of it needed?) or perhaps fetch it lazily (on demand).<br /><br
/>Thanks,<br/> Sefer.<br /><br /><br /><br /><br /><hr />Hotmail: Free, trusted and rich email service. <a
href="http://clk.atdmt.com/GBL/go/196390708/direct/01/"target="_new">Get it now.</a>