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

Re: PgAdmin 3 startup

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Michael Shapiro <mshapiro(at)ncsa(dot)edu>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: PgAdmin 3 startup
Date: 2003-12-29 22:42:58
Message-ID: 3FF0ADF2.3030103@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
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



In response to

pgadmin-support by date

Next:From: vidhyaDate: 2003-12-30 03:51:19
Subject: switching postgres from windows to linux
Previous:From: Andreas PflugDate: 2003-12-29 22:38:00
Subject: Re: pgadmin bug

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