Skip site navigation (1) Skip section navigation (2)

Slow connect due to some queries

From: Tzvi R <sefer(at)hotmail(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Slow connect due to some queries
Date: 2010-01-13 16:16:46
Message-ID: BAY118-W504468B9AD2468E78AD0BAA86B0@phx.gbl (view raw or flat)
Thread:
Lists: pgadmin-support
Hi,


I've been using pgAdmin for a long time but over time it has become more and more frustrating to use it.
It's a great application that performs everything I need, however, when first connecting to servers with many databases, each with many tables, views and other objects (over a VPN) it can often take 20-30 seconds while pgAdmin is hung before it completes running all the prefetch queries.

I've analyzed its logs and it appears that some queries are the main culprit.


For example (15-20 seconds to run this):
SELECT oid, format_type(oid, NULL) AS typname FROM pg_type

We have quite a few entries there (every toasted table, every view and every table have a couple of entries there).
SELECT count(*) AS typname FROM pg_type
35468

Also, this same query gets apparently issued twice:
2010-01-13 09:44:15 QUERY : Set query (pgdb:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type
2010-01-13 09:44:31 QUERY : Set query (pgdb:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type
2010-01-13 09:44:52 STATUS : Restoring previous environment... (37.31 secs)

Causing the application a long time to "connect".
I was wondering if there's either a way to bring a partial subset of the data (is all of it needed?) or perhaps fetch it lazily (on demand).

Thanks,
       Sefer.




    

 		 	   		  
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
http://clk.atdmt.com/GBL/go/196390708/direct/01/

Responses

pgadmin-support by date

Next:From: Abdallah MEHDOINIDate: 2010-01-14 18:04:42
Subject:
Previous:From: Rathod, AashishDate: 2010-01-13 00:03:03
Subject: can't get pgpass.conf to work with pgagent

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group