Michael,

> With a particular database, PgAdmin3 takes a very long time to connect to a 
> database. this is not a general problem with PgAdmin, but only with one 
> database out of many. Other databases do not have the problem. And only 
> with one particular server. The exact same database on a different server 
> does not have the problem.

Have you run VACUUM ANALYZE *as the superuser* on the faulty server recently?  
>From the look of the explain, PG is grossly underestimating the number of 
items in the pg_trigger and pg_depend tables, and thus choosing an 
inappropriate nested loop execution.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to