Re: [pgadmin-support] PgAdmin 3 startup

[Andreas Pflug]

Michael Shapiro wrote:

I have downloaded the latest snapshot of pgadmin3 
(pgadmin3-20031228-Win32.zip) and connected to a database. PgAmin 
takes 150 seconds to complete its startup.

2003-12-29 15:16:26 QUERY  : Scalar query (delphi:5432): 

SELECT COUNT(*) FROM
(SELECT tgargs from pg_trigger tr
LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
WHERE co.oid IS NULL
GROUP BY tgargs
HAVING count(1) = 3) AS foo

2003-12-29 15:16:26 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:52 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:52 QUERY  : Query result: 0
 

Apparently this query is the offending one. It really should finish 
quite fast.
I wonder if you a) have a lot of unmigrated constraint triggers and/or 
b) a lot of tables and never vacuumed the system tables.
Please check this and give some feedback.

Regards,
Andreas


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster